Help with Importing from Excel into Access

Discussion in 'Microsoft Access' started by Sethm, Jul 5, 2012.

  1. Sethm

    Sethm

    Joined:
    Jul 5, 2012
    Messages:
    1
    Likes Received:
    0
    Hey all, first post on this site!I have read quite a few posts on this matter but I cannot find an answer for my case, or one that I can change to fit me, for that matter.

    I have an excel sheet that has numbers as well as "#N/A" cells in it. When I import these cells into Access, the cells that have "#N/A" are not importing. I know that this is a Type Conversion Failure and why it is doing it.

    I cannot change the input excel file. I am looking for an alternative way to either A. get these in from the input, or B. look into the ImportErrors file that is created and add these values into the other sheet from this. This is how I am inputting it.

    Code:
    DoCmd.TransferSpreadsheet acImport, , "source", source_plus_name, True
    I know that I could change to TransferText, but this is is causing: "Run-Time error '31519': You cannot import this file."

    Would it be easier to create a temporary file and do TransferText (even though most are numbers), or find a way to do one of the two things I posted above?
     
    Sethm, Jul 5, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Leonard Priestley

    Importing Excel Spreadsheet into Access 97

    Leonard Priestley, Dec 13, 2003, in forum: Microsoft Access
    Replies:
    2
    Views:
    209
    Leonard Priestley
    Dec 13, 2003
  2. Guest
    Replies:
    1
    Views:
    261
    M.L. Sco Scofield
    Apr 2, 2004
  3. RobFMS
    Replies:
    0
    Views:
    269
    RobFMS
    Apr 30, 2004
  4. mike
    Replies:
    3
    Views:
    255
    '69 Camaro
    Aug 12, 2004
  5. Andrew Good
    Replies:
    2
    Views:
    313
    Jamie Collins
    Aug 27, 2004
Loading...

Share This Page