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

OLEDB MsAccess Data from Accpac

P: 2
We would like to create an MsAccess.Mdb (or SBF or Sequel database) in office 2000 to obtain individual table details from Accpac Plus in Dos (an accounting program)?

This Access data will be used for viewing and printing and not for accounting purposes.

Can we receive any ideas or a sample database of how to do this?

Thank you
Mehran
Jan 8 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 1,646
We would like to create an MsAccess.Mdb (or SBF or Sequel database) in office 2000 to obtain individual table details from Accpac Plus in Dos (an accounting program)?

This Access data will be used for viewing and printing and not for accounting purposes.

Can we receive any ideas or a sample database of how to do this?

Thank you
Mehran
Hi. Don't know what database Accpac uses. Probably encrypted as accounting info is normally required to be secure. Perhaps you should look at the output options. Maybe you can output a csv file and import that into access
Jan 8 '07 #2

NeoPa
Expert Mod 15k+
P: 31,661
As Will says, maybe the best way is to export from AccPac (CSV format but there are other possibilities also) and import this data on a regular basis into Access.
I don't think Access has been programmed to link directly into AccPac so there could be no live feed.
Jan 8 '07 #3

Post your reply

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