View original (French)

Conversion of Excel chart of accounts to SAGE i7 format

Solved
cosowin -  

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

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

    1
    1. cosowin Author

      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