Exporting Queries or Tables to CSV

[epoh97 via AccessMonster.com]

How can I export Queries or Tables to CSV in VBA or VBScript?

Thanks,

I havent found much in Access's 2003 Help

 

[Ken Snell \(MVP\)]

Look up TransferText in VBA Help. It's a method of DoCmd object.

 

[epoh97 via AccessMonster.com]

Never mind, I found it.
DoCmd.TransferText acExportDelim, , "Table1", "c:\table1.csv", "-1"

 

[epoh97 via AccessMonster.com]

Thanks