Automating saving query output as a csv file

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

Guest
I am trying to write a module to automatically save the output from a query in an external csv file, without input by the user. I have tried docmd.runcommand acFileSaveas followed by a series of sendkeys statements, but the sendkey statements seem to be ignored and a dialog box appears on the screen.
 
Can u use the docmd.transfertext command ?
 

Users who are viewing this thread

Back
Top Bottom