acSpreadsheetTypeExcel

Discussion in 'Access External Data' started by ken, Oct 7, 2004.

  1. ken

    ken Guest

    I'd like to import an Excel 2000 spreadsheet using the
    TransferSpreadsheet command. Which acSpreadsheetTypeExcel
    should I specify?

    Ken
     
    ken, Oct 7, 2004
    #1
    1. Advertising

  2. ken

    BerHav Guest

    Hi Ken,

    Excel 3 : acSpreadsheetTypeExcel3
    Excel 95 : acSpreadsheetTypeExcel7
    Excel 97 : acSpreadsheetTypeExcel8
    Excel 2000 : acSpreadsheetTypeExcel9 (Default Value!)
    Excel 2002 : acSpreadsheetTypeExcel10
    Excel 2003 : acSpreadsheetTypeExcel11

    As Type 9 is the default value you don't need to mention it.


    Regards,
    Bernd

    "ken" wrote:

    > I'd like to import an Excel 2000 spreadsheet using the
    > TransferSpreadsheet command. Which acSpreadsheetTypeExcel
    > should I specify?
    >
    > Ken
    >
     
    BerHav, Oct 7, 2004
    #2
    1. Advertising

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. jaydh

    acSpreadsheetTypeExcel

    jaydh, Feb 19, 2005, in forum: Excel Misc
    Replies:
    3
    Views:
    738
    Myrna Larson
    Feb 20, 2005
Loading...

Share This Page