I would like to use a .bat file to run a query which exports to an MS Access file. However, no matter what I do, it exports a text file. Is there any way to accomplish this? I am using SQL Assistant 12.0. Thanks for any insight you can provide.
Sorry, it appears that part of the description of the -e parameter is missing from the version 12.0 user guide.
The following is from a later version but applies to 12.0 as well.
For Export files use: -e <name>
Export the results of your query to a file named <name>. The format of this file is determined with Export options currently in effect.
If the export file is a Microsoft Access database, the file name must be followed by a backslash '\' and the tablename.
For example: -e c:\temp\MyDatabase.mdb\MyTable