Importing from Excel to Access 2007
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER