+ Reply to Thread
Results 1 to 3 of 3

Subscript Out Of Range Error on Improting Excel Worksheet to Access

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Newark, DE
    MS-Off Ver
    Excel 2010
    Posts
    23

    Question Subscript Out Of Range Error on Improting Excel Worksheet to Access

    I received this error trying to import and Excel worksheet to an Access table. The field names are the same between Excel and Access. Where should I start to solve this problem? How would I toubleshoot this?

    Thanks,
    Steve
    Newark, DE

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,249

    Re: Subscript Out Of Range Error on Improting Excel Worksheet to Access

    Steve,
    I did a google search on this error. There seems to be many different scenarios that may be causing this. I suggest you google it also, and look through the issues that others have experienced and maybe there will be something that clicks for you. There appear to be issues with Date/Time, number of fields, autonumbering. To many issues to list. Good luck as I think it will be a case of trying different things and ruling them out until you find the causation.

    Alan
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-28-2013
    Location
    Newark, DE
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Subscript Out Of Range Error on Improting Excel Worksheet to Access

    Thanks Alan. I ened up exporting the Excel worksheet to a NEW Access table and it works fine. There must have been a conflict with my trying to export to an existing table.

    Steve

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1