Export to text

  • Thread starter Thread starter ChoonBoy
  • Start date Start date
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, ""
 
Sorry for duplicate entries.

The message that appear after my posting indicated that there was an error.

Regards
 
Back
Top