In MS Access, is there a way using VBA to export an arbitrary DBF file to CSV format without needing to manually export it first / create a specification file? I just want to make a function that will work for any DBF. Is there a function that does this already?
Not an arbitrary file, but you can use
DoCmd.TransferDatabase acLink, ...
' and
DoCmd.TransferText acExportDelim, ...
to first link a specific dBase file, then export it to a text file. Using neither an import/link specification nor an export specification, the commands will use the default settings of Access.