• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1490
  • Last Modified:

Can Access connect to a DB3 database

My company uses a DB3 (clipper) for its inventory. How can I use MS access to link to this database either directly or by creating an ODBC connection.

0
dumontls
Asked:
dumontls
  • 4
  • 3
1 Solution
 
svenkarlsenCommented:
Hi dumontls,
You will need an ODBC connector from Clipper, -from then on the principles are standard ODBC access.

Kind regards,
Sven
0
 
dumontlsAuthor Commented:
the databse is actually a dbase III version and they use Xdot as an interface
0
 
svenkarlsenCommented:
Hi Dumont,
then yo can connect directly to the inventory database, - just link the dbase datasets directly into your Access database and you can use them like any other Access table.

Regards,
Sven
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
dumontlsAuthor Commented:
how do i that
0
 
svenkarlsenCommented:
dumontls:

From Access menu: Files > Get external data > Link tables

 then you select the DbIII file you need and follow the instructions.

You may need to go through the process a couple of times to get comfortable with the options, - don't worry if you make a link and regret it: you can just delete the link in the Access Database window (it will not influence or harm the DbIII-file in any way).

Regards,
Sven
0
 
dumontlsAuthor Commented:
Thanks, what i always used to do in the past was to import the whole file and then try to manipulate the data.

Now I might be able what I have already reduced from a days work to an hours work to even less

Thanks Sven muvh appreciated

Louis
0
 
svenkarlsenCommented:
Most glad to be of help!

Sven
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now