Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / September 2005

Tip: Looking for answers? Try searching our database.

Importing Excel - "Subscript out of Range"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sondra - 12 Sep 2005 21:26 GMT
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] - 13 Sep 2005 03:59 GMT
Tell us how you're doing the import....what is the filename.... etc. etc.

Signature

       Ken Snell
<MS ACCESS MVP>

>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.
Sondra - 13 Sep 2005 15:00 GMT
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.

   
   

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

CESS MVP>

> >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] - 13 Sep 2005 15:47 GMT
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.
Signature


       Ken Snell
<MS ACCESS MVP>

> The following are the steps I am taking to import the file:
>
[quoted text clipped - 25 lines]
>> >
>> > Please advise. \
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.