Solved

SQL2005 - export to Excel

Posted on 2007-12-06
9
2,319 Views
Last Modified: 2008-03-27
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
Comment
Question by:dcass
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 7

Expert Comment

by:macentrap
ID: 20425228
Use Import Export Wizard or a DTS package,
DTS has been renamed as SQL Server Integration Services (SSIS) in SQL 2005
0
 
LVL 5

Expert Comment

by:ursangel
ID: 20426296
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
 

Author Comment

by:dcass
ID: 20427862
So there is no tab for import/export in SQL 2005.  I have to install Visual Studio 2.0?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:dcass
ID: 20428087
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
 
LVL 7

Expert Comment

by:macentrap
ID: 20431541
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
 

Author Comment

by:dcass
ID: 20434030
I have excel 2003 - will try.
0
 
LVL 7

Accepted Solution

by:
macentrap earned 500 total points
ID: 20435142
>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
 
LVL 5

Expert Comment

by:ursangel
ID: 20439650
I think if you dont have sqlserver 2005 better go with importing from excel option.
macentrap have suggested the steps for the same.
0
 

Expert Comment

by:dneill8
ID: 21227829
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Select - Finding chars in a column 2 61
Sql Permission 6 59
Sql query 107 59
SQL Server 2005 - Comparing Fields' Contents 6 32
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question