Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2329
  • Last Modified:

SQL2005 - export to Excel

How do you export an SQL 2005 table to an Excel spreadsheet?  It was easy in 2003 but can't figure it out with 2005.  For that matter, I need to be able to import, as well.
0
dcass
Asked:
dcass
  • 3
  • 3
  • 2
  • +1
1 Solution
 
macentrapCommented:
Use Import Export Wizard or a DTS package,
DTS has been renamed as SQL Server Integration Services (SSIS) in SQL 2005
0
 
ursangelCommented:
SSIS is teh newer version of DTS in SQL 2005.
You need to create  project in VS 2.0 of type Integration services.
In the dataflow page, add two components one for Source of type OLEDB Source and other destination whihc is your Xcel destination.
Double click the componenets and set thier properties like the data source, table name etc.
save the project and run it...

hope this will help you move ahead.
0
 
dcassAuthor Commented:
So there is no tab for import/export in SQL 2005.  I have to install Visual Studio 2.0?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
dcassAuthor Commented:
can I not just set up a query - select var1, var2 from datatable and then have some way to tell it to export to an Excel file and click Execute?
0
 
macentrapCommented:
if you wont to export values from the table then you can do that in excel.
for this you have to setup ODBC connection  betweeen your system and SQL server,
Open excel and call the table from there

In Excel 2007
 Data\from other sources\from SQL server
Connect to Database Server\{enter Servername}\{windows authentication}
Select the database
connect to specific table {NEXT}
Finish

Which version of Excel you using, Hope this helps {as excel 2003 } is similar too
0
 
dcassAuthor Commented:
I have excel 2003 - will try.
0
 
macentrapCommented:
>Excel 2003
>Open Excel
> Data
> Import External Data
> New Database Query
> Select my System DSN from the list of databases

Will you be okay setting up ODBC connection?
0
 
ursangelCommented:
I think if you dont have sqlserver 2005 better go with importing from excel option.
macentrap have suggested the steps for the same.
0
 
dneill8Commented:
This seems rather an 'import to excel' solution rather than an 'export to excel' solution.  The effect is the same but the tools one works with are different.  This throws a search for working with MS SQL tools off.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now