Importing Data into MS Access with ODBC - Importing the tables from MSDE

(Page 5 of 6 )

The following screen shows up, where you make choices as to the tables you want to link to. Tables are the only objects you may link to. The prefix dbo for the tables indicate they are being linked with dbo permissions. Highlight the tables you want to link to, and click OK. You may also save the password with the link so that you may not need to enter this information again.

You are done!

Now the link to the tables has been established as seen in this picture. Four tables have been successfully linked using the ODBC Connection to the MSDE database. Table names have come over with a dbo prefix and the icons show that they are ODBC database tables.

Next: Imported table/Original table comparison >>
 

More Microsoft Access Articles
More By Jayaram Krishnaswamy

Comments On: Importing Data into MS Access with ODBC

· ODBC makes connecting to databases so easy. From legacy text file stored data to...    · You did if we may say two very excellent ASP SQL Server tutorials. One was on,...    · Yes you can import the tables. The tables will be part of your MS Access database...   >>> Post your comment now!