Exporting a Access table/view from command line with VB Script

  • Thread starter Thread starter Karen Middleton
  • Start date Start date
K

Karen Middleton

Many thanks to John Nurick I was able to import any arbitrary file
into a Access table in a database.

I want a similar VB script which can take a command line argument
consisting of a Access database , file path and access table/view name
and export the Access table/view into a delimited file specified.

Thanks
Karen
 
The script is very much the same; the main thing is that instead of
building and executing a query to import from a textfile, you build and
execute one to export to a textfile. Here's an example:

SELECT * INTO [Text;HDR=Yes;Database=C:\Folder\;].FileName#txt
FROM My_Table;
 
Back
Top