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

Is it possible to link Access to a customized program?

P: 22
Hello,
I don't have much experience with Access, but I was wondering if it possible to link data stored in a program like CardScan to Microsoft Access?

If so, is there a command or extension I need to be using to achieve this?

The idea I have is to call stored data CardScan to a MS Access form.

Thanks in advance!
Jul 28 '10 #1
Share this Question
Share on Google+
4 Replies


beacon
100+
P: 579
Hi flower,

I don't have any experience with CardScan, so forgive me if my response is way off base.

Does CardScan have an ODBC connection? If so, you can link to the data using the Link Tables option (File -> Get External Data -> Link Tables).

Just in case you aren't familiar with ODBC connections or aren't sure how to check if a connection exists, (Assuming a Windows-based Operating System) go to your Control Panel -> Administrative Tools -> Data Sources(ODBC) and then check under the User or System tabs for a data source.

If it's there, when you choose the Link Tables option, you'll change the 'Files of Type' selection at the bottom of the dialog box that appears.
Jul 28 '10 #2

P: 22
Thank you beacon,

I don't have CardScan in my computer so I can't really do much with it.
But to solve my proble, someone exported the CardScan data into an excel file and I linked that file to a table in Access and created a query. From that query, I'm pulling out information.
I see the inconvenience of doing this, but I can't do much without the CardScan software.

Thank you for your suggestion. If I get the software, I'll do what you suggested.
Jul 30 '10 #3

beacon
100+
P: 579
Cool...if you're familiar with linking, then if you get CardScan, or at least gain access to the ODBC for the database that CardScan uses it will be a piece of cake for you to link to it instead of the Excel file.
Jul 30 '10 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
You may not need the cardscan software. I stress may, as it varies greatly between softwares. Some software will only require the odbc driver installed to allow you to set up your own odbc connection. My advice would be to check out odbc connections on the softwares own site. They may have information posted.
Aug 4 '10 #5

Post your reply

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