• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2333
  • 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
dneill8IT ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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