- Click on Blank Database and then
on OK.
- Enter a filename with an ".MDB" extension,
then click on Create.
- Click on File, then Get External
Data, and then Import
- In the Files of Type: box select
Text Files (*.txt, *.csv, *.tab, *.asc).
- In the Look In: box either select
your floppy (A:\) drive or go to the directory
on your hard drive that you saved the file
to.
- In the File name: box, enter the
name of the file you saved and click on the
Import button.
- The Text Import Wizard then starts.
Check to see that the Delimited button
is checked. Click on Next.
- Check to see that Comma is the selected
Delimiter.
- If the file that you saved has fields names
in the first row then put a checkmark in the
box that says First Row Contains Field
Names and click on Next again.
- If you would like to import the information
into a new table, select In a New Table.
If you would like to import the information
into an existing table, select Existing
Table and choose the correct table. (Note:
The existing table that you are importing
into must have the same fields as the file
you are importing). Click on Next again.
The next two screens are for changing field
options and adding primary keys. Click on
Next two more times.
- In the Import to Table: box, type
in a name you want to call this table. Then
click on Finish.
- Double-click on the new table that appears
in the window and you will see the data you
downloaded.
Your Records are now Imported!
|