Sage Export Data using ODBC

Hi,

I need to write an export program for a client to export from their SAGE Line 50 2008 package.    I have all of the DTA files and what I believe are the ODBC drivers S11DBC32.dll and S14DBC32.dll.  I do not have SAGE installed on my development machine.  All I need to be able to do is link to the DTA in a VB.net APP, loop round each record and export it to a CSV.  Can I do this with the files I have and if so how?

thanks
LVL 2
kintonAsked:
Who is Participating?
 
Bruce DenneyConnect With a Mentor Sage 50 Consultant and IntegratorCommented:
You don't need the S11DBC32.dll driver as that is for an older version.

There is an installer for the driver in the Sage installation directory, in the ODBC subdirectory, if you need it.  

Warnings: The drivers are very slow, if you are looking to do lots of lookups, then you would do welll to cache the tables first.  The drivers are READ only.

0
 
kintonAuthor Commented:
thanks, I am working on this Monday so will let you know the outcome
0
 
kintonAuthor Commented:
Hi,

That works fine, but I'm asked for a username and password when connecting through Access/Excel.  our customer typically has no idea what it is and the password they use to login to SAGE does not work?  Any ideas how I may find this?

I'll award the points anyway as you have answered my original question but if you can give any pointers on this it would be helpful!

thanks

Darren
0
 
kintonAuthor Commented:
This was the solution, just need the password from sage!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.