Subscript Out Of Range Importing XLSX



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