mapping fields from a csv text file to a database table

  • Thread starter Thread starter BJ Meincke
  • Start date Start date
B

BJ Meincke

I have student information in a csv text file from my
local school board and I need to import records from that
file into an existing datbase table we use to keep track
of student attendance.

The data type is the same, but the field names between our
table and the text file data don't match, and so I need to
know how to map the csv field names to our table's field
names.

Thanks,
BJM
 
Hi BJ,

Just click the Advanced... button in the text import wizard. This allows
you to assign fieldnames.

I have student information in a csv text file from my
local school board and I need to import records from that
file into an existing datbase table we use to keep track
of student attendance.

The data type is the same, but the field names between our
table and the text file data don't match, and so I need to
know how to map the csv field names to our table's field
names.

Thanks,
BJM
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Thanks for your reply John.

I can see the option you describe if I opt to import the
data to a new table, but not when I opt to import it to an
existing one.

BJM

-----Original Message-----
Hi BJ,

Just click the Advanced... button in the text import wizard. This allows
you to assign fieldnames.

I have student information in a csv text file from my
local school board and I need to import records from that
file into an existing datbase table we use to keep track
of student attendance.

The data type is the same, but the field names between our
table and the text file data don't match, and so I need to
know how to map the csv field names to our table's field
names.

Thanks,
BJM
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
it does not matter that the fields names don't match. Just make sure that
you click the check box to let the import wizard know that the first row is
headings. What you have to make sure is that the order of the csv file
matches the order of the Access table. This may require you rearranging the
field names in the table to complete the import.
 
Alternatively, you can temporarily link to the textfile, and then use an
Append query to move the data from the linked table to the main table.


Thanks for your reply John.

I can see the option you describe if I opt to import the
data to a new table, but not when I opt to import it to an
existing one.

BJM

-----Original Message-----
Hi BJ,

Just click the Advanced... button in the text import wizard. This allows
you to assign fieldnames.

I have student information in a csv text file from my
local school board and I need to import records from that
file into an existing datbase table we use to keep track
of student attendance.

The data type is the same, but the field names between our
table and the text file data don't match, and so I need to
know how to map the csv field names to our table's field
names.

Thanks,
BJM
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top