Importing Delimited Text to MS Access: Step 2

The data will be imported into a table within your database. Start MS Access and either open an existing database or create a new one.

In MS Access (we are using MS Access 2000 for Windows in this example) go to the File menu, then select Get External Data and then select Import.

The window below will appear asking you to select the file you want to import. Change the "Files of type" field to "Text Files", select the data file, and click on Import.

Import window in MS Access

Next step

If you require further assistance with the instructions or information on this page, contact the IT Support Center.