By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,282 Members | 1,587 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,282 IT Pros & Developers. It's quick & easy.

Importing Records from Sage to Access

P: 84
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 :)
Feb 21 '08 #1
Share this Question
Share on Google+
9 Replies


Minion
Expert 100+
P: 108
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 -
Feb 21 '08 #2

Scott Price
Expert 100+
P: 1,384
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
Feb 21 '08 #3

Scott Price
Expert 100+
P: 1,384
A quick Google of Sage Instant Accounting 6 gave me this site as well.

Regards,
Scott
Feb 21 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
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)>
Feb 21 '08 #5

P: 84
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.
Feb 22 '08 #6

P: 84
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
Feb 22 '08 #7

P: 84
nvm i found the answer :)


http://www.sageforum.co.uk/viewtopic...ghlight=export

if anyone else needs
Feb 22 '08 #8

Scott Price
Expert 100+
P: 1,384
Glad you found something that works! And thanks for posting back with a solution.

Regards,
Scott
Feb 22 '08 #9

P: 1
Check out SageDataObjects.com, they have an API that you can use for the import.
Apr 17 '08 #10

Post your reply

Sign in to post your reply or Sign up for a free account.