I need to export data from a table to a .csv file so it can be imported to
another application. I exported from the table and built a query via
import/export DTS. I exported to Excel, because I couldn't get the .csv
driver to work. I would build a DSN but it would not show in the list. I can
get the the DTS to run and export to Excel, but how can it get it to
overwrite each time if exports? Now, it is appending in the spreadsheet when
run. If someone has a better suggestion on how to get this done, please let
me know.