Access 2003 Solution Center

Import/Export

Supported data sources for importing, for exporting, and for linking in an Access database
Supported data sources for importing, for exporting, and for linking in a Microsoft Access database
How to use data transformation services (DTS) to export data from a Microsoft Access database to an SQL Server database
Describes the method of using DTS to import or export data between SQL Server and any OLE DB or ODBC data source. Includes the steps to copy the order tables from the Northwind database to a new database by using the DTS Import and Export Wizard.
Supported data sources for importing, for exporting, and for linking in an Access database project
Describes the kinds of programs and file formats that you can link data to in an Access 2003 database project. Although you can import or link databases, tables and lists, you cannot modify their structure. Access support various data formats.

How to use Paradox data with Access and Jet
Tells you that you need to install Jet 4.0 Service Pack 5 or the BDE so that you can write data to a Paradox database in Access. If you do not do this, the Paradox database can only be accessed in read-only mode.
Description of the Microsoft Office Access 2003 post-Service Pack 1 hotfix package: March 26, 2005
Describes the Access 2003 post-Service Pack 1 hotfix package that is dated March 26, 2005. Lists the issue that the hotfix package fixes and contains information about how to obtain the hotfix package.
Nulls replaced with next field's data when You export to Microsoft Excel
Describes the problem when you export data to the Microsoft Excel file format, null values are replaced with the data that should be in the next column in the resulting spreadsheet.

You receive an error message when importing, exporting or linking text files
Describes that you may a "Invalid setting in Excel Key of the Engines section of the Windows Registry" error message when you use the Export Text Wizard to import, export or link a text file.
You cannot connect directly to FoxPro databases in Access 2007 and in Access 2003
Describes a problem that may occur where you may not be able to import, export, or link to FoxPro databases directly in Access. You can use Microsoft Visual FoxPro ODBC driver to resolve this problem.
Skipped fields are imported when you import data from a comma-delimited text file to an existing table
Describes the problem where the fields you select to skip in the Import Specification dialog box are still imported to the existing table. You can workaround this problem by either saving the import specification or importing the data to a new table.