Export to Excel with pass through query

[de muur]

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

 

[Guest]

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)