View original (French)

Conversion of Excel chart of accounts to SAGE i7 format

Solved
cosowin Posted messages 8 Status Member -  
cosowin Posted messages 8 Status Member -

Hello,

I have an accounting plan on SAGE and I want to import it into Sage 100 Accounting i7 8.50. The problem is that SAGE accepts a specific format for the import (CSV format with indexed formatting using commas as separators, ...)

Can you help me find an easy tool to convert my Excel file and import it directly?

Thank you


2 answers

  1.
    contrariness Posted messages 17903 Registration date   Status Member Last intervention   6 243
     

    You might be able to go through Word..
    Import your Excel file into Word, use the "find/replace" function to add your formatting..

    1
  2. cosowin Posted messages 8 Status Member
     

    Thank you @contrariness StatusMember. I am looking for a small tool (VB, macro,...) for which I input the Excel file, and it outputs a file that can be directly imported.

    0