Export to Excel with pass through query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

de muur - 26 Aug 2005 13:33 GMT

With the command TransferText, I've tried to export data from an Oracle
database with a pass through query to Excel. The answer of Acces is:
Operation is not supported for this type of object.

My question is, is it possible to export to Excel with a pass througt query
on an another way?

Thanks in advance

Reply to this Message

david@epsomdotcomdotau - 28 Aug 2005 01:22 GMT

try using a make table query instead of transfer text.

codedb.execute "SELECT PTQ.* INTO
[EXCEL 8.0;database=C:\FILE1.XLS].TABLE1
FROM PTQ;

(david)

> With the command TransferText, I've tried to export data from an Oracle
> database with a pass through query to Excel. The answer of Acces is:
[quoted text clipped - 4 lines]
>
> Thanks in advance

Reply to this Message