sql server data warehouse: Hi,
I am new to SQL Server and need to load the data from Excel Sheet into a SQL
table? Could anyone please help ?
Thanks

Look into the DTS (data transformation packages) in the EM and read a bit in
the BOL. Its fairly straightforward.
Alternativley, you could check eymaples on OPENQUERY


MC


[quoted text, click to view]

Hi Harsh,
I have done so much of this over so long that I finished up writing a
generic workbook reader that can then attach to any ODBC data source
and write the data to that data source.....I wrote it in VB....it only
reads excel sheets in XML format as that was easier and the next
release of office will support all functions in XML.

It only takes an hour or so to add a new wworkbook to the reader/write
based on the table it is writing to.

We are finding it to be a really useful tool as we can now make excel
the default data entry tool for all those bits and pieces of data that
live nowhere else...and everyone has excel on their desktop and eveyone
knows how to use it.

If you (or other readers) want to discuss how this is done write to me
offline....peter@peternolan.com.

Peter
www.peternolan.com