Problem with TransferSpreadsheet in Access 2007

[Carl Rapson]

I'm having a problem with the TransferSpreadsheet method in Access 2007. The
TransferSpreadsheet method is exporting a query to Excel, and it has been
working fine under Access 2002. Under 2007, however, Access seems to
truncate up some of the query column names, with the result that Access
doesn't recognize them and prompts me for values for those columns. The
problem is reproducible, occurring on the same columns every time. If I open
the query directly the column names are fine and it exports to Excel with no
problems; it seems to happen only with the TransferSpreadsheet method.

Has anyone else had any problem with TransferSpreadsheet under Access 2007?
Or has anyone seen a problem like this? Thanks for any information,

Carl Rapson

 

[Carl Rapson]

I actually found how to work around the problem. It turns out I had to turn
on "Export data with formatting and layout" in the Export wizard. Checking
that box allowed the export successfully.

Carl Rapson