Import returned an Subscript Out of Range Error

R

Roberta

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?
 
G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top