How do I import data from Excel into an existing table in Access when the information doesn't necessarily overlap? Is that possible or would I have to go in and modify each of the field names in Excel to match with the ones in my table?
Novice
Windows XP 
Access 2010 32bit
How do I import data from Excel into an existing table in Access when the information doesn't necessarily overlap? Is that possible or would I have to go in and modify each of the field names in Excel to match with the ones in my table?
Novice
Windows XP Access 2010 32bit
Let me just say that, I think I am doing it right, but everytime I finish it tells me the "Subscript is out of range"
Competent Performer
Windows XP Access 2010 32bit
Some days back I also suffered with this error, After copying the data into a new worksheet, I was able to import the data into a new table successfully.
Importing data from excel:
Posting Permissions
Reply With Quote