Results 1 to 9 of 9

Thread: Bad Import

  1. #1
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601

    Thumbs down Unanswered: Bad Import

    I am trying to bring in a file from excel. It says "Subscript out of range." I can hit next, but I get that error each time. But when I am done it says it cannot be imported. Help please

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Do you use the wizard to import a table from Excel to Acce$$?

  3. #3
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Yes I do. I don't know another way to do so.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Look up the OutputTo


    Example

    DoCmd.OutputTo acOutputTable, yourTableName, acFormatXLS, yourOutputFilename & ".xls"

  5. #5
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    That looks like I am pushing it out into a xls file. I need the xls file in..

  6. #6
    Join Date
    Dec 2003
    Posts
    268

    Just an idear

    Is there too many columns in the data from Excel? i think MSAccess will choke on over 128 columns in a table (WHY WOULD ANYONE EVER WANT TO DO THAT!!!!!!!!) anyhoo. take a look there.

    if that doesn't work, try splitting the excel spreadsheet up into to two worksheets in a new workbook and give that shot.

  7. #7
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Well the data fills up columns A-S ...So what's that, around 20? But when I do the wizard, there is many many columns following the last. I tried to delete them I couldn't, so I just hid them. Now excell acts as they aren't there which is fine.

  8. #8
    Join Date
    Jul 2004
    Posts
    5
    Hi rguy84,

    I think mjweyland is correct. If you're unable to delete the extra columns, try copying the needed data to another excel file.

    Good Luck
    D

  9. #9
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Ok will do.

    [EDIT] Yup it worked, Weird
    Last edited by rguy84; 07-13-04 at 13:35.

Posting Permissions

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