FormerMember

how to paste multiple rows of cells from excel to sage

Posted By FormerMember

Is there a way to copy a set of 100 cells (100 rows deep by 1 column wide) and paste those into excel?  Right now doing it one by one and sure takes a long time.....

Thank you

  • FormerMember
    0 FormerMember

    The SQL database editor allows multiple cell copy /paste

  • 0

    In general you can't paste multiple cells/rows of data from an Excel Spreadsheet into Sage. There are some exceptions.  The best method to accomplish this will depend on what tables you are trying to update. in many applications data can be IMPORTED from an Excel Spreadsheet (saved as a CSV).  We would need more specific information to answer your question.   SQL editor won't work for what you are asking here.  Most inquiries can be conditioned and then exported to Excel if you are trying to get data from Sage 300 CRE into an Excel spreadsheet.