TransferSpreadsheet Error

[DJ]

I am using the DoCmd.TransferSpreadsheet method in an Access Form to export
Data to an Excel workbook. Sometimes the method works, sometimes I get the
following error:

Error Number: 3310
Error Description: This property is not supported for external data sources
or for databases created with a previous version of Microsoft Jet.

The table being exported is actually a query, and the database has been
created with the current version of Jet (4.0). Can anyone help me with this
issue?

Thanks,

DJ

 

[Danny J. Lesandrini]

Are there functions on the query? Are any properties set on columns of the
queries, like date format or the like? Can you do a TransferSpreadsheet on
the table successfully?

 

[DJ]

Hi Danny,

First of all thank you for your response.

There are a few functions on the queries, mostly SUM functions. There are
no properties on any of the columns for formats filters or otherwise. I
have not tried a TransferSpreadsheet on the table, as it is a huge table and
I only need certain information. I can however try a test if needed.

The biggest issue I have is that the method works most of the time and
decides to give me the aforementioned error on some occasions.

Thanks again for your help.

DJ