Export data from access to CSV

[amillia]

Basically, what I need to do is export all of the work order numbers out of an access table to a csv file on the server and it needs to be scheduled to work daily. Can I do this.

 

[grande]

I honestly don't know how to get it to work daily, but I know that it's possible. Try searching the forums.

As far as exporting goes, try something like this:

DoCmd.TransferText acExportDelim, "", "tbl_or_qry_ofTheStuffYouNeed", "C:\textfilename.csv", True

-------------------------
Just call me Captain Awesome.