SQL PassThrough - Export CSV error

N

Nicodemus

Hello,

In MS Access I connect to TeraData server through ODBC.
I've built an SQL PassThrough query (named 'Q_Test') that extracts the data
I need.
This query works perfectly (ODBC TimeOut property set to 3600 seconds).
Now I want to execute this query and export the outcome to a CSV file via
VBA :
DoCmd.TransferText acExportDelim, , "Q_test", "C:\temp\Q_test.csv", True

When running the VBA code, I get the following msg after +- 5minutes :
“Time error 3251 Operation not supported for this type of objectâ€

Does anyone know a solution/workaround to get the query result being
exported to CSV ?

Thank you already for any help
Nicodemus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL PassThrough query - CSV error 0
SQL PassThrough query - CSV Error 4
Parameters, Passthrough UpdateQueries, and SQL 7
Export Access Query to a pipe delimited .csv file 5
Export of text field trims leading zeros 1
Export to csv with headers 1
ADP CSV export 0
Export with Conditional Statement 4

Top