carlosjcabral
New Member
- Joined
- Dec 30, 2005
- Messages
- 28
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.