Load data using Microsoft SQL Server

Microsoft SQL Server includes a data loading tool called the Import and Export Data Wizard. Using the wizard, you can load data from text files (fixed-format, delimited format, and variable length records), Microsoft Excel files, Microsoft Access, various ODBC data sources, and other products. See the SQL Server documentation for more information about the types of files that you can use.

Additionally, your data administrator might have a preferred method for loading data. See your database administrator for more information.

If you are importing text files into SQL Server 2000, make sure that you manually select the import table. You need to select this table even if it is already selected. This is because the Transform dialog of the Import and Export Data Wizard is set by default to recreate the table rather than append to it, and the default column names used are incorrect. Selecting the table manually resets this to append to the existing table instead using the correct column names.