Subscript Out Of Range Importing XLSX

R

Rob

Ok - Here is another SOOR question. I have read all the other posts and
nothing mentioned seems to fit.

I tried to import an XLSX into Access 2007 table and receive Subscript Out
Of Range error (using Import Wizard). To correct the problem, I compress and
repair the db and rerun import - works fine.

I have to do this each time I load this particular table ? Any ideas on
what to check. Why does Compress and Repair correct the problem only once ?

Thanks Rob
 

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

Similar Threads

subscript out of range 1
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Import from Excel - Subscript out of range 2
Subscript out of range 2
Subscript out of range messge while importing from Excel to append 8
subscript out of range 9
Subscript out of range 4
What causes "Subscript out of range" during Access import? 1

Top