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

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

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.