Automating saving query output as a csv file (1 Viewer)

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.
 

nick

Registered User.
Local time
Today, 13:54
Joined
Mar 27, 2000
Messages
12
Can u use the docmd.transfertext command ?
 

Users who are viewing this thread

Top Bottom