Exporting Data from excel to SQL Server express

Hi

I have managed to add the DTS wizard as a tool and saved the routine. However, I do not know how to schedule my PC to automatically run this DTS procedure. I have tried to use scheduled tasks, but it does not seem to want to start.

Pls help.

It was absolutely amazing.

Just by typing in "SQL Server" and Excel in the search box on this page in the forums, I found these previous posting on the same topic...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1083746&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295895&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=970723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=304674&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=985930&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1083317&SiteID=1

There were more...

|||

Hi Arnie,

Thanks for the suggestion, I discovered a a previous post you made. You suggested that you get scheduled tasks to run dtsrun.exe. I do not have DTSrun.exe and surely you would have to make the executable run only your specified saved DTS 'routines'. How would you do this?

Regards

George

|||

Perhaps these will help guide you.

DTS - How to Run a DTS Package as a Scheduled Job
http://www.support.microsoft.com/?id=269074

DTSWizard.exe
http://go.microsoft.com/fwlink/?LinkId=65111

|||

Hi

Thank you for your help, but unfortunately the above solutions do not seem to work. Let me explain my situation more completely:

I have installed Microsoft SQL Server Express Edition with Advanced Services SP2 and the Toolkit. I have made the DTSWizard a tool in SQL management studio express I have transferred sample data into the database using the DTS tool. I have 'saved' the DTS transfer|||

For command line details about executing a 'package', refer to Books Online, Topic: dtutil

Exporting

Hi

I built a new sql server database and want to export its content to a .sql file. How to do it? (EM, QA ?) Thanks

Exporting the tables,views,sp ... can be done using the SQL Managment Studio. Right click and script the database.

If you want to export data then you will need a software that will generate the INSERT queries. Search google about SQL scripting ...

HTH
Regards

Export wizard exports views as tables

Hi

I have a problem using SQL 2005 Export wizard.

I have 2 databases : DB1 and DB2

DB1 has X tables and Y views
DB2 has W tables and Z views

I want to export only few selected views from DB1 to DB2.

In Import and Export wizard, I select these views and execute the export-package. Completed Successfully.

And finally the problem:

All views that i exported from DB1, are not placed in DB2 as views, but as TABLES!

Why?

Waiting for your quick answer,
Martin

This is by design.

It may happen that some of the tables on which the view depends are not imported at all, which can cause the view definition to fail.

Thanks,

Kuntal

Export wizard exports views as tables

Hi

I have a problem using SQL 2005 Export wizard.

I have 2 databases : DB1 and DB2

DB1 has X tables and Y views
DB2 has W tables and Z views

I want to export only few selected views from DB1 to DB2.

In Import and Export wizard, I select these views and execute the export-package. Completed Successfully.

And finally the problem:

All views that i exported from DB1, are not placed in DB2 as views, but as TABLES!

Why?

Waiting for your quick answer,
Martin

This is by design.

It may happen that some of the tables on which the view depends are not imported at all, which can cause the view definition to fail.

Thanks,

Kuntal

export trace file to excel?

Hi
I would like to export all the information in my trace file to excel so I
can do a sort. Any suggestions on how to do this? I tried the standard copy
and paste method but the data didnt group correctly. Thanks.You can load the data from the trace file to a table using the
fn_trace_gettable system function and then pull the table into Excel.
Normally best done using SELECT INTO for minimal logging. BOL has good
examples for fn_trace_gettable.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||Theresa,
One possible approach:
1. Save the trace to a table in the database.
2. Use the export wizard to export the table to an Excel spreadsheet.
-- Bill
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.|||Hi Theresa
Why don't you load the trace into a SQL Server table? You can sort a table
very easily.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.|||Thank you!! That works great!
"Plamen Ratchev" wrote:

> You can load the data from the trace file to a table using the
> fn_trace_gettable system function and then pull the table into Excel.
> Normally best done using SELECT INTO for minimal logging. BOL has good
> examples for fn_trace_gettable.
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
>

export trace file to excel?

Hi
I would like to export all the information in my trace file to excel so I
can do a sort. Any suggestions on how to do this? I tried the standard copy
and paste method but the data didnt group correctly. Thanks.
You can load the data from the trace file to a table using the
fn_trace_gettable system function and then pull the table into Excel.
Normally best done using SELECT INTO for minimal logging. BOL has good
examples for fn_trace_gettable.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
|||Theresa,
One possible approach:
1. Save the trace to a table in the database.
2. Use the export wizard to export the table to an Excel spreadsheet.
-- Bill
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.
|||Hi Theresa
Why don't you load the trace into a SQL Server table? You can sort a table
very easily.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.
|||Thank you!! That works great!
"Plamen Ratchev" wrote:

> You can load the data from the trace file to a table using the
> fn_trace_gettable system function and then pull the table into Excel.
> Normally best done using SELECT INTO for minimal logging. BOL has good
> examples for fn_trace_gettable.
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
>