Problem with TransferSpreadsheet in Access 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl Rapson - 31 May 2007 20:17 GMT

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

Reply to this Message

Carl Rapson - 31 May 2007 21:08 GMT

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

> I'm having a problem with the TransferSpreadsheet method in Access 2007.
> The TransferSpreadsheet method is exporting a query to Excel, and it has
[quoted text clipped - 10 lines]
>
> Carl Rapson

Reply to this Message