Using SQL Spreadsheets
Scheduling a task
an import task non-interactively, the SQL Spreadsheets command line
interface (SQLSpreadsheetsCmd.exe) is used. The first parameter
must be the name of the import task file.
then need to enter a name for the task, and choose the frequency to
run this task.
you have set up the relevant schedules, you will need to enter the
account details of a user that has permission to run the import.
This user must also have permission to access your database if you
are using Windows authentication as the logon method (e.g. for SQL
that is completed, SQL Spreadsheets will display a summary of the
task settings. Click Finish
save the task into the Windows Task Scheduler.
can then use the Windows Task Scheduler to edit any of the task
settings in the future.