Importing Excel - "Subscript out of Range"

[Guest]

I am trying to begin a new database by importing an excel worksheet. I keep
getting an error message "subscript out of range". Nothing imports.

Please advise.

 

[Ken Snell [MVP]]

Tell us how you're doing the import....what is the filename.... etc. etc.

 

[Guest]

The following are the steps I am taking to import the file:

1. Open a Blank Database
2. Choose "Get External Data" from File Menu
3. Choose "Import"
4. Choose the file name "SOP_ROUTING_LOG" from the list of Excel Files
5. Choose Import
6. Show Worksheets option
7. Choose "Next"

**Error Message pops up:

!Import Spreadsheet Wizard
Subscript out of Range

That's my problem.

Thanks.

 

[Ken Snell [MVP]]

Try re-registering the EXCEL wizard file. Here is generic info regarding
this:

Re-register the following files:
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))

Also, try re-registering this file:
Accwiz.dll

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

Or run from Start | Run window (example):
Regsvr32 "path\msexcl40.DLL"

etc.


Also, if the path to the file is quite long, it may fail to open the file.
You could try moving the file to a folder where the path to that folder is
much shorter.