Importing from Excel to Access 2007
Posted on 2013-01-15
I have a Access 2007 DB that I am having an issue importing an Excel sheet.
The main issue is that the Excel sheets top header row doesnt the Access table field names.
If I manualy select all rows and columns from the Excel sheet and paste them into the Access table it works fine but I have a macro button that I want to use to import. I get errors when I try to use my macro because the field names dont match. when I change the Excel field names to match the Access table field names the macro works fine.
So, I get this excel import once a week. Is there a way to fix the macro so that I can import the excel data without having to always change the field names?