Excel CSV to MAS 500

**bja** · 03-11-2014, 06:18 PM

Hi everyone.

Using VBA, I have converted an xlsm file to .csv for importing into MAS 500 but having done so (as part of a project), we have been told by a Sage employee that you cannot import a .csv file into MAS 500.

Their website infers otherwise.

Normally I would put this to a MAS 500 forum but while researching this issue, I came upon a number of threads coming from the Excel side of the fence as the .csv files usually come from Excel. Those threads (some from back in 2006) indicated the import was common but Sage claim it cannot be done.

Anyone have any clear understanding of this process?

TIA.
Cheers,
BJA

**Richard Buttrey** · 03-11-2014, 06:41 PM

Hi,

It would be strange if it didn't. This site says it does http://na.sage.com/~/media/site/sage...nager_spec.pdf

**martindwilson** · 03-11-2014, 06:44 PM

well a quick google search says the Sage MAS 500 ERP Data Import Manager supports
IMPORT DATA TYPES
• SQL Server
• ASCII Files
• Delimited (CSV)
• Microsoft Access
• Microsoft Excel
• XML

**bja** · 03-12-2014, 09:48 PM

Yes, I also came upon these sites which is why the confusion. Turns out the Sage employee is NOT a Sage employee, just a reseller who apparently like to enter data manually... at a cost of course.

Thanks guys.
Cheers,
BJA

**Richard Buttrey** · 03-13-2014, 05:53 AM

Originally Posted by bja

Yes, I also came upon these sites which is why the confusion. Turns out the Sage employee is NOT a Sage employee, just a reseller who apparently like to enter data manually... at a cost of course.

Thanks guys.
Cheers,
BJA

Probably mostly true but I'd hazard a guess that the reseller won't be adding data manually, he'll be using a csv file.