Importing Records from Sage to Access

[metalheadstorm]

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 :)

[Minion]

If you end converting to a csv (comma seperated value) file then I would check out the Import csv (Comma Separated Value) File tutorial on this board. This should help you read into your db from a file.

Though I was wondering what the current format for the records is? I'm personally not familar with the Sage software, so I don't knwo what file format the records may be in.

Hope this helps.

- Minion -

[Scott Price]

Sage, isn't that the same company that bought Act! contact manager from Symantec awhile ago? Have you tried looking on their website for any related information?

Act! allows you to export to a text delimited file, does the Instant Accounting software provide similar functionality?

Regards,
Scott

[Scott Price]

A quick Google of Sage Instant Accounting 6 gave me this site as well.

Regards,
Scott

[missinglinq]

If I understood your original post correctly, you're using Access as a backend only with a VB 6 frontend. I would think you'd be better off concentrating on how to import this data thru VB6 and posting this question on that forum. You Access backend, after all, only contains tables, does it not?

Linq ;0)>

[metalheadstorm]

Act! allows you to export to a text delimited file, does the Instant Accounting software provide similar functionality?

Regards,
Scott

I cant find any function to export data from sage instant accounts 6 to either a text file or a excel file.

[metalheadstorm]

ive looked so far and i cant find anything , but i still got lots of post to go on either of ther forums :S

most of them are for ACT! which isnt the same as sage instant accounting

[metalheadstorm]

nvm i found the answer :)

http://www.sageforum.co.uk/viewtopic.php?t=4264&highlight=export

if anyone else needs

[Scott Price]

Glad you found something that works! And thanks for posting back with a solution.

Regards,
Scott

[dananos]

Check out SageDataObjects .com, they have an API that you can use for the import.