outputing table to excel file using VBA Access 2000

[Chris]

H

I have a VBA module that I want to use to output an Access 2000 table to an excel spreadsheet

the code is

DoCmd.OutputTo acOutputTable, "xBExport", acFormatXLS, "ScotiaTrackBranchExport.xls", Fals

this code worked in Access 97

I then converted the database to Access 2000

I get the following error: runtime error 2281: the formats taht enable you to output data as an MS Excel are missing or incorrectly registered in the Windows registry

I checked my references to make sure using the accesss 2000 DAO and object library, etc

Does anyone know the answer to this problem

thank

Chris

 

[Hedi]

Your ISAM driver could be hosed in the registry.
Do you see the "Microsoft Excel(*.xls)" as part of the
combo box the "Output Format" of an OutputTo macro? (you
need to create an new macro to see this)
If you don't then you ISAM driver that comes with Jet is
not registered right.

Hedi

-----Original Message-----
Hi

I have a VBA module that I want to use to output an

Access 2000 table to an excel spreadsheet.

the code is:

DoCmd.OutputTo acOutputTable, "xBExport",

acFormatXLS, "ScotiaTrackBranchExport.xls", False

this code worked in Access 97.

I then converted the database to Access 2000.

I get the following error: runtime error 2281: the

formats taht enable you to output data as an MS Excel are
missing or incorrectly registered in the Windows registry.

I checked my references to make sure using the accesss

2000 DAO and object library, etc.