subscript out of range when importing from excel

Posted on 2009-02-24
Last Modified: 2012-05-06
Any idea about this message that i get when trying to import data from excel to ms access, same fields, sames types.
Question by:titorober23
    LVL 92

    Expert Comment

    by:Patrick Matthews
    Hello titorober23,

    Are you running code?  If so, what is it, and what line does the debugger jump to?



    Author Comment

    no just basic import window, i select the table and choose import select the file, everything goes finf till i click finish i tjust said "subscript out of range"

    Accepted Solution

    I just check the date fields, and select the same format as ms access and then works smooth
    LVL 58

    Expert Comment

    This could be caused by invalid characters in the sheet name, for example. Microsoft doesn't always agree with Microsoft when it comes to that... Can you try it with a workbook called "Book1", from a sheet called "Sheet1" (and, while we are at it, to a table called "Table1")?

    LVL 58

    Expert Comment

    Sorry, missed your last post. You solved it, then? -- (°v°)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now