SQL, ODBC, and MS ACCESS

[JeremyAnderson]

Ok I am new to the Database world and need some advice. I am creating an MS Access database using Office XP. I need to pull data from a remote SQL database. I have setup a connection to the database via ODBC Data Access Adminstrator, and can pull data from the SQL db to an Excel doc, but how do I pull it form the SQL db to the Access db? Any help will be GREATLY appreciated!!!

Thanks in advance,
Jermey

 

[k5tm]

In the File menu/Get External Data/Link Tables...

The help topic is "About importing and linking data and database objects"

Tom Morrison

http://www.liant.com

 

[JeremyAnderson]

Awesome, so now all I need to know is how to link certain columns in the SQL db to certain columns in the Access db. ANy ideas??

 

[k5tm]

The tables you create using Link Tables... are real tables. Treat them that way.

If you are saying that you don't know how to do joins in SQL, this would be the wrong forum, try forum700 instead. (But you might discover something in the Help for MS Access that will lead you to a solution.)

Tom Morrison

http://www.liant.com