Importing Data into MS Access with ODBC - Imported table/Original table comparison

(Page 6 of 6 )



Design view comparison

These two pictures show the design of the tables that were linked and the original table design in the MSDE database. The data types in SQL Server are different from those of MS Access, and the linked table design features are not allowed to be altered.

 

Comparison of tables

 

 

Summary

This step-by-step procedure should help in establishing ODBC links to tables in MSDE. The procedure is generic and can be used for other databases which one can find, or download drivers from third party vendors. As it was seen in this tutorial, the linked table data types will be those of the MS Access native type rather than of the originating database. The table design cannot be changed in the linked tables. Using MS Access with linked tables can effectively shield applications from data and make data accessible to a number of applications sharing the same data.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

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!