| Import a text file into an Access database Tutorial | ||
|
Import records into your Access database table by importing the data which is held in
a text file. The text file already has all the fields separated by commas which Access then
reads and dumps into your Access database. What you will need to complete this set of steps is: |
||
|
||
| 1) |
Open your Access database.
|
|
| 2) |
Make sure that the table that you are importing to is not open. On the File menu select File > Get External Data > Import. 
|
|
| 3) |
Browse to the directory that contains your import text file. In other words, the file
that was exported from the Web application. Select the Files of type as Text Files located near
the bottom of the selection box with scroller.
|
|
| 4) |
Highlight the text file and click Import.
|
|
| 5) |
Look at the Sample data box to ensure things look correct and then click Next.
|
|
| 6) |
Check the First Row contains Field Names checkbox and click Next.
|
|
| 7) |
Select In an Existing Table and the select your table which will receive the new
data and then click Next.
|
|
| 8) |
Click Finish.
|
|
| 9) |
Click Ok.
|
|
| 10) |
Check your database table to ensure that the data was imported correctly.
|
|
|
www.datamenus.com |
||