Data Export to Excel - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Data Export to Excel

Author

Topic

svicky9
Posting Yak Master

232 Posts

Posted - 2006-02-07 : 15:52:52

Hi

What should I select in the destination col of the wizard to export the sql server 2000 table to excel 2003

(I selected the Microsoft Excel 97-2000) but none of the data seems to be exported..Suggestions please

thanks
Vic

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-07 : 16:10:11

Yes that is the right thing to select as Excel 2003 can open older formats. Are you sure you are selecting the correct table to export? Please let us know what you have filled in on each screen of the wizard.

Tara Kizer
aka tduggan

svicky9
Posting Yak Master

232 Posts

Posted - 2006-02-07 : 16:11:44

quote:
Originally posted by svicky9

Hi

What should I select in the destination col of the wizard to export the sql server 2000 table to excel 2003

(I selected the Microsoft Excel 97-2000) but none of the data seems to be exported..Suggestions please

thanks
Vic

It shows only the first column in the data destination as F1 and the datatypes are termed as "<ignore>"

Am i proceeding correctly?

thanks
Vic

svicky9
Posting Yak Master

232 Posts

Posted - 2006-02-07 : 16:22:09

This is the brief description

I want the customers table of northwind to exported to the excel sheet on the desktop by using a filtered query so that i get the cols i wanted

I used the following procedure

a.data source : Microsoft Sql Server Local
Database : Northwind
Login:Windows Authentication

b.data Destination : Microsoft Excel 1997-2000
Location : Desktop/sqlextract.xls

c.selected the option use a query to transfer
" select * from customers"

d.Transform --> changed the destination to sheet1$

** In the transform destnation table i see the datatypes as <ignore>
what does this mean

Morever when i click run it copies only the customerID and hence i can see only one col

What could be the problem

Thanks
Vic

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-08 : 03:41:36

Try this also
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources