03333 445950
Home
Up

                                

 

Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Sage 50 Import of CSV Data 

The Sage 50 import process (V2011 (V17) and later) for earlier see here

1/ Make sure that the CSV data is valid and complies with the rules

2/ Run the Import process in Sage 50, this is a two part process,

Log in as Manager (or your user ID if you have access rights to import)
Go to File Menu and select the Import option to start the import wizard

Click Next

Highlight the type of record you are importing
Click Next

Select the type of file, xls or csv
tick the box "First row contains headings" if you want to skip the first line of the import
Navigate in the browsing window to your import file and select open.

For each importable sage field, select the Imported field that matches it from your data file.
Once you have made your map you can save it with the Save map button and re-use it next time by using the load map button
The process in this new version is a bit more long winded and a bit more flexible, if you want a quick and easy solution take a look at our Custom solution
Click Next and then Finish to start the import.

Sage runs a test the first time and if everything is okay it does a second pass, during which it import all the data into sage 50.  The process is ALL or NOTHING, if it fails on one record all the records will fail to import.

3/ Fix any problems highlighted by the import.  It is quite possible that you have missed something even though you were really careful with your data preparation, so be prepared to go back fix mistakes and run step 2 again.

 


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017