Import to access where headers match

[carlosjcabral]

I'm not quite sure how to do this. I have a MS access table with many columns. I also have data from excel that will always have the same header names as the access table, but not all of them will match. For example: my Access table will have Column 1,2,3,4 but my excel table will only have a Column 2 and 4. How do I have Excel match the header name with access and import the data into those columns only? Is this possible? Any help you can provide would be great.

 

[meguilbert]

What I have done in the past was set up a linked table in access to my excel worksheet. Then created a query with the missing columns. I do not know if what you are looking for can be done. Try WWW.utteracess.com also.

HTH,
Matt