03-04-2012 06:03 PM - edited 03-04-2012 06:30 PM
One of your customers uses Sage ACT. They have given us a file output from Sage and we need to convert it to our in house SQL database to run our analysis on. We do not have Sage installed.
Is there any way to do this?
I can open the file in Notepad++ and can see the data, but there are a whole lot of invalid characters as well.
Thanks in advance
03-04-2012 07:57 PM
Why not download trial copy of ACT! (runs for 30 days) and restore the database so you can open it in ACT! and then run analysis. You could export to Excel depending on want data you want to retrieve, or connect via OLEDB etc.