|
<< back to technical support
Importing data: Microsoft Access
-
Click on Blank Database and then on OK.
-
Enter a name for your new database and then click on Create.
-
Once the new database is created, click File > Get External Data >
Import.
-
In the Files of Type dropdown, select Text Files (*.txt, *.csv, *.tab, *.asc).
-
In the Look In box, browse to the file you received from us.
-
Click on the filename and then click Import..
-
When the Text Import Wizard starts, make sure the Delimited box is checked and
click Next.
-
Select Comma as the Delimiter..
-
If the file contains the field names in the first row, check the First Row
Contains Field Names box and click Next.
-
To import the data into a new table, select In a New Table. Otherwise, to
import the data into an existing table, select Existing Table and choose the
table you want to import into. The existing table must have the same
fields as the file you are importing. Click on Next.
-
You may change field options on the next few screens, if you wish, but these
are primarily for more advanced users. Otherwise, click Next twice.
-
In the Import to Table box, choose a name for this new table and click Finish.
-
Your data is now imported.
<< back to technical support
|