Export to Excel with pass through query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top