Importing Excel - Maintaining column order

[HiTekRedNek]

Hi, I've been using MS Access 2007 for years to manage some Excel data. running some queries etc. Just recently I've been encountering problems when importing data into an existing table. When I do it now, I get a "Subscript out of Range" error. To troubleshoot, I imported into a new table and when doing so, the fields no longer match the column order of the spreadsheet. They all get imported but appears in a different order. I think this is why I am getting the error message. How can I go about ensuring that the data gets imported properly into my already existing table? My fields in "Design View" will match the order of the Columns in the Excel spreadsheet.

Kind Regards,

​

 

[HiTekRedNek]

No replies!!! Just to explain a bit further here are what the columns look like in order. 1. System Name 2. Assignment Path 3. Agent Version (deprecated) 4. Last Communication To test my issue I imported the Excel data into a new Access table and in 2 different places the fields are out of order. In Access it looks like this 1. System Name 2. Assignment Path 3. Agent Version (deprecated) 4. Engine Version (VS Ent) Why does the problem start when it comes to importing the 4th column? It should be the "Last Communication" header but instead it imports the "Engine Version" column (Which is actually the 6th column in the Excel Spreadsheet)