Need to export an SQL statement

  • Thread starter Thread starter Preston Pierce
  • Start date Start date
P

Preston Pierce

I need to export a select statement and I cant do it
through a query. I need to do it through code...please help?
 
Hi Preston,

Often it's simplest just to have your code create or modify a QueryDef
and export that. Other possibilities are:

-Have your code incorporate the SELECT statement into a SELECT INTO
(make-table) statement that uses an IN clause to specify the database or
file you want to export the data to.

-Recordset operations and automation (e.g. if exporting to Excel).

-Recordset operations and file I/O operations (if exporting to textfiles
or a custom format)
 
Back
Top