C
ChoonBoy
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, ""
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, ""