vb: importing excel sheet into access table

Discussion in 'OT Technology' started by DiabSoule!, Jan 22, 2004.

  1. DiabSoule!

    DiabSoule! ooh, plum been runnin', buck a doz. ooh, smoke ba

    Joined:
    Mar 15, 2000
    Messages:
    5,000
    Likes Received:
    0
    Location:
    Toronto, Canada
    I'm stumped on this one. Trying the following SQL statement with no luck.

    INSERT INTO crexport (GF3_PRTNUM_11, GF3_PMDES1_01, GF3_PLANID_01, GF3_CLSCDE_01, GF3_ONHAND_01, GF3_week, GF3_displaydemand)
    SELECT F1, F2, F3, F4, F5, F6, F7 FROM [EXCEL 8.0 ; HDR=NO; IMEX=2 DATABASE=C:\text.xls]"

    the error i receive is that it cannot find the test.xls file, when it is there.

    :confused:
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    test.xls is there but is text.xls there?
     
  3. DiabSoule!

    DiabSoule! ooh, plum been runnin', buck a doz. ooh, smoke ba

    Joined:
    Mar 15, 2000
    Messages:
    5,000
    Likes Received:
    0
    Location:
    Toronto, Canada
    you know, that would have been something.. :o

    but no, i changed the statement to read test.xls and same thing.
     
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Is the excel version correct?
     

Share This Page