This is Urgent! :)
Ok im using Ms Access (2002) as the backend to a program i have developted in vb6, this is for a college project and im currently at the business that this poposed program is for. They use Sage Instant acounting 6 as ther current system and have thousands of records for invoices / customer etc (there invoice count is up to about 58,000
So my question is how do i transfer the records for ther customers, products and invoices to my access db.
I was thinking of copying / converting the sage record to a text or excel file then importing them to access.
If anyone has a tutorial or ideas how to do this please say :)