In MS Access 2000, I am trying to automate the export of a table into a comma-delimited file (.csv). When I have the table open, I can export to that format no problem, but when I try to export in a macro using the 'Output To' command, the file-output format choices are limited. What I'm thinking is that I could somehow modify the VB code to be able to accomplish what I want, but I'm not sure how to designate a csv as the output format in code. I thought the below might be a way to do it, but no dice.
DoCmd.OutputTo acTable, "HierarchyOutput","Comma-Delimited File", "C:\test.csv", False, ""
Does anyone have any ideas?? I'd appreciate any advice!! Thanks again for all the help all the time!
DoCmd.OutputTo acTable, "HierarchyOutput","Comma-Delimited File", "C:\test.csv", False, ""
Does anyone have any ideas?? I'd appreciate any advice!! Thanks again for all the help all the time!