Export to text

[Alcsy]

I am trying to export a text file but without success. The objective is to
use the sql statement below instead of using a save query to do the text
transfer. Any help appreciated and thanks in advance.

Dim strsql as string

Strsql =â€SELECT qryCountItmUsers.[Item No], Count(qryCountItmUsers.Cust) AS
CountOfCust, qryCountItmUsers.[Sman Code] FROM qryCountItmUsers GROUP BY
qryCountItmUsers.[Item No], qryCountItmUsers.[Sman Code];â€


DoCmd.TransferText acExportDelim, "", " Strsql ", "c:\RMDB\TblOrders3a.txt",
False, ""

 

[Ken Snell \(MVP\)]

TransferText will not export a query unless it's been saved.

Although the examples use TransferSpreadsheet, similar logic could be
employed with TransferText -- see my articles to see how to use tempoary
queries for such exports:

Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate EXCEL files via TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSepFiles


Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate Worksheets within one EXCEL file via
TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSameFile

 

[Alcsy via AccessMonster.com]

Thanks for the reply and the links provided more than what I expected.

Regards

TransferText will not export a query unless it's been saved.

Although the examples use TransferSpreadsheet, similar logic could be
employed with TransferText -- see my articles to see how to use tempoary
queries for such exports:

Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate EXCEL files via TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSepFiles

Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate Worksheets within one EXCEL file via
TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSameFile

I am trying to export a text file but without success. The objective is to
use the sql statement below instead of using a save query to do the text

[quoted text clipped - 10 lines]

"c:\RMDB\TblOrders3a.txt",
False, ""