get sheets list in a excel file

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

SQL Server Development (2000)

get sheets list in a excel file

Author

Topic

entec_van
Starting Member

5 Posts

Posted - 2006-10-11 : 05:33:02

hi,I use SQL Server 2000, and I need to get sheets list in a excel file. Please help me! thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-11 : 05:36:02

Use DTS or SSIS if you want to import Excel data.

Peter Larsson
Helsingborg, Sweden

entec_van
Starting Member

5 Posts

Posted - 2006-10-11 : 05:48:04

thanks Peso,
but I currently use OpenRowSet, and I need to get sheets name list,
how can I do it?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-11 : 06:25:06

I don't think you can.
Look at this VERY extensive topic about importing data from Excel with OPENROWSET
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Peter Larsson
Helsingborg, Sweden

entec_van
Starting Member

5 Posts

Posted - 2006-10-17 : 00:32:18

If I only need to get list of sheets name in a excel file, how can I do it?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-21 : 08:46:09

quote:
Originally posted by entec_van

If I only need to get list of sheets name in a excel file, how can I do it?

Do you use front end application like vb?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources