SqlDbx Forum

SqlDbx

You are not logged in.

#1 2010-04-23 12:26:15

Blane
Guest

Command Line Options

Is there a way to export using a command line option?  I would like to use this tool with Windows Scheduler to on a specific day of the month connect to a database, run a query, and export the results to an excel file using the path and file name I specify.  Just wondering if this is possible with this tool or if it could be added?

#2 2010-04-23 12:30:02

Blane
Guest

Re: Command Line Options

Also, could you do what I previously asked from a command line and have it append to an existing Excel file?

#3 2010-04-23 20:17:57

sqldbxhelp
Administrator

Re: Command Line Options

SqlDbx is a interactive user program and not really a command line tool.
In general it is possible to add more command line functionality, but I am
not sure it belongs in SqlDbx.

Offline

#4 2019-09-18 11:29:01

IcePaperWalking
Member

Re: Command Line Options

i have similar question. i wrote the export excel in the sql. and want to find a way to execute the sql script via task scheduler daily

Offline

Board footer

Powered by FluxBB