ODBC connections

10 pts.
Tags:
Database
DB2
Desktops
Management
Microsoft Windows
Oracle
OS
Security
Servers
SQL
SQL Server
We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to extract a merge file for use in mailing. You just have to set up an ODBC connection to the database". How in the heck do I do this? I did something on the server the other day - I thought making this so called connection. Then if I go into Access and click on File, New and then on the right hand side click on Blank Data Access page, then click on New Source, click next and then enter the Server information - it doesn't show up in the list. If someone can help me do this I would greatly appreciate it. Completely new territory for me. Thanks. Loran

Answer Wiki

Thanks. We'll let you know when a new response is added.

you have to know what kind of database it is so you can pick the correct provider when creating an ODBC data source. Once you create the data source, you can use Access to open up that data source.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following