Subscript Outside of Range

[Jill Kennel]

When importing an Excel spreadsheet into an Access table, everything between the spreadsheet and table MUST be the same. The field names in the Excel spreadsheet must match EXCACTLY the same in the Access table field names.

If one column in Excel is called "FirstName" but in Access the name is "First Name", the import will produce errors. If the field name in Excel is "Phone", but the name in Access is "Phone Number", the import will produce errors.

The formating of the data type in the two tables must be the same. If Phone is a number in Excel and text in Access, the import will produce errors.

It is a good idea to analyze the Excel spreadsheet's makeup before attempting to import it into Access. Upper case or lower case letters do not matter. Spaces are text and are important when going between different applications.

[code green]

This is simply down to the way the Access import tool is written.
Most of these problems can be circumnavigated by writing your own bespoke VBA script.
Please don't misunderstand, I am not debasing your useful tips,
I am reminding people that there is more to IT work than Microsoft Wizards