Ask the Expert

Setting up ODBC driver for migration

How do I set up an ODBC driver to migrate tables from Access 2000 to an Oracle Database?
The easiest thing to do is to install the Oracle Client software on your workstation. This will install the ODBC driver. In Control Panel->Administrative

    Requires Free Membership to View

Tools, there is an ODBC manager. With this tool, you can Add a new ODBC Data Source Name (or DSN). Now go to MS Access and choose File->Export. In the Save File As box, choose ODBC Datasources(). The wizard will then ask you which DSN to use. Use the DSN you created above.

This was first published in January 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: