Importing an Excel file

[Tony Williams]

I have an Excel that I need to import on an almost daily basis into an Access
2003 database. I have created the fields in the table with names that follow
the normal convention, avoiding spaces etc. However the column names in the
spreadsheet will not be the same as the field names in the table. Is there
anyway that I can automate the mapping of the fields so that the data from
the columns goes into the right field in the table or would it be easier to
adandon the idea of properly structured filed names and just use the column
headings as field names?
Thanks
Tony

 

[Douglas J. Steele]

You could link to the spreadsheet, then run an Append query that takes the
data from the spreadsheet and puts it in your table.

 

[Tony Williams]

Thanks for that pointer Douglas. What about the differing field/column
names? I remember when I used to use Lotus Approach in the Dark Ages, when
you imported data you had an opportunity to map fields together. I don't
seem to be able to find the same facility in Access 2003. Am I correct or
have I missed it?
Thanks again, as ever.
Tony

 

[Douglas J. Steele]

When you linked to the spreadsheet, your linked table would have the names
of the columns in the spreadsheet. In your Append query, you'd do the
mapping between the Excel names and the Access names.

 

[Tony Williams]

Thanks Douglas I'll try that.
Merry Christmas and Happy New Year!
Tony