Access 2003 versus Access 2007 Excel Import

Discussion in 'Access VBA Modules' started by clk, Aug 7, 2012.

  1. clk

    clk Guest

    Hi. I have a database that takes an Excel spreadsheet from an outside
    vendor (have no control on the spreadsheet format) and imports it into
    a database. This process updates records for custoemrs.

    The problem is the code works PERFECTLY in Access 2003. I take that
    same database and open it in Access 2007 or 2010 and the import
    process is not consistent. The Policy Number field which is
    alphanumeric field and set to a text field in Access will drop the
    entries if they have letters in the field. Treating it like a number
    field. In Access 2003, it imports 100% correctly.

    This is the line of code:

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
    "AAExportData", strImportFilePath & strImportFileName, True

    Another thing, if I manually import it in to Access specifically
    stating that field is a text field it will work. Even if I save
    import specs it doesn't seem to work.

    Should the code be different for Access 2007/2010?
     
    clk, Aug 7, 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. Daniel Dickover

    Closing form versus X-iting form

    Daniel Dickover, Dec 15, 2003, in forum: Access VBA Modules
    Replies:
    1
    Views:
    88
    Alex Dybenko
    Dec 15, 2003
  2. Joe Wroblewski

    Macros versus VB Code

    Joe Wroblewski, Feb 21, 2004, in forum: Access VBA Modules
    Replies:
    6
    Views:
    79
    Marshall Barton
    Feb 21, 2004
  3. Victor Holtcamp Removeifyouaren'tspam

    Array versus temporary recordset

    Victor Holtcamp Removeifyouaren'tspam, May 14, 2004, in forum: Access VBA Modules
    Replies:
    1
    Views:
    128
    Chris Nebinger
    May 14, 2004
  4. bjnova

    Early versus dispid binding

    bjnova, Nov 1, 2004, in forum: Access VBA Modules
    Replies:
    7
    Views:
    196
    bjnova
    Nov 3, 2004
  5. ID10Terror

    Displaying data versus actual data

    ID10Terror, Mar 30, 2005, in forum: Access VBA Modules
    Replies:
    1
    Views:
    123
    Alex Dybenko
    Mar 30, 2005
  6. shannacu

    Access 2002 versus 2000

    shannacu, Feb 13, 2007, in forum: Access VBA Modules
    Replies:
    1
    Views:
    82
    Alex Dybenko
    Feb 14, 2007
  7. dch3

    Access versus SQLServer

    dch3, Aug 18, 2008, in forum: Access VBA Modules
    Replies:
    7
    Views:
    140
    david
    Aug 19, 2008
  8. dch3
    Replies:
    8
    Views:
    142
    Michel Walsh
    Nov 25, 2008
Loading...