Web Development - UD Application Help Pages

Importing Delimited Text to MS Access: Step 2

Questions should be directed to Web Development, it-webdev@udel.edu

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

Previous step  Next step