Excel Source

Question

Excel Source

Praxy

Mr or Mrs. 500

Points: 573
More actions
May 29, 2008 at 5:34 am

#182917

hi
i am Prasanna
I have a excel source (only one excel , having many sheets )
,, in that source we find many sheet, each sheet is having data
so i m just trying to load that data of each sheet to single sql server destination how to do it .

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

prasukj (5/29/2008)
hi
i am Prasanna
I have a excel source (only one excel , having many sheets )
,, in that source we find many sheet, each sheet is having data
so i m just trying to load that data of each sheet to single sql server destination how to do it .

http://support.microsoft.com/kb/321686

http://www.google.com/search?hl=en&q=OpenRowSet+excel

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Praxy Mr or Mrs. 500 Points: 573 More actions · Answer 2

Praxy

Mr or Mrs. 500

Points: 573

May 29, 2008 at 7:59 am

#821762

Thanks WayneS

it worked out really:)

mishracse Grasshopper Points: 23 More actions · Answer 3

Hi Prasanna

i also want multiple xl sheets insertion into sql table .have u used SSIS package

please tell how u did in ssis package