Import returned an Subscript Out of Range Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access table that I want to import an Excel worksheet to. The
fields in the worksheet are identical to the fields the in Access table.
Import is not successful and returns error "Subscript out of Range". Any
ideas?
 
that error has several meanings
1. the data went all the xl sheet.
2. could not find the sheet or location.
3. could not find the workbook
 
without seeing your code, i don't know what the fix is.
the error you are getting could mean several things, i
only provided you with some possiblities.
Post your code and i will see what i can find.
 
Back
Top