Header issues Importing From Excel

[andy_42 via AccessMonster.com]

I have many template excel worksheets that multiple people will be populating
every few weeks. The spreadsheet templates will have headers such as "Job
Title", "Department Name", "Employee ID" etc. My access table does not have
spaces in the field names "Deptname", "jobtitle", "EEID". My problem is that
when I import how do I have access recognize which spreadsheet column should
be inserted into which field?

Is there an easier method to handle this import without changing the
spreadsheet header to match the access table names before import?

Thanks in advance for any advice to manage this import process.

 

[Jeanette Cunningham]

Hi andy,
One way is to have a separate table that the initial import goes into, then
use append queries to extract the data from that initial table and put it
into the table with the field names "Deptname", "jobtitle", "EEID.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia