How to use data transformation services (DTS) to export data from a Microsoft Access database to an SQL Server database (285829)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
This article was previously published under Q285829 Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2000 version of this article, see 250616.
SUMMARY
Data Transformation Services (DTS) is an alternative method that you can use to move data from an Access database to Microsoft SQL Server.
Note The previous version of Microsoft SQL Server 2000 Desktop Engine was called Microsoft Data Engine (MSDE). Unlike MSDE, the SQL Server 2000 Desktop Engine does not include DTS and the DTS Import and Export Wizard.
Note Using DTS to move Access tables creates the Unicode character fields nChar, nVarChar, and nText by default. These fields may cause problems when linking from Access 97, which does not support Unicode. Microsoft recommends that these fields be converted to Char, VarChar, and Text when linking from Access 97.
REFERENCES
For more information about DTS and the DTS Import and Export Wizard, please refer to SQL Server Books Online at the following Microsoft Web site:
Modification Type: | Minor | Last Reviewed: | 6/7/2004 |
---|
Keywords: | kbDatabase kbdesign kbExport kbImport kbhowto KB285829 |
---|
|