Startup Parameter to export to MS Access?

Tools & Utilities

Startup Parameter to export to MS Access?

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.

Thanks,

Paul

1 REPLY
Teradata Employee

Re: Startup Parameter to export to MS Access?


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