|
Home > Archive > MS SQL Data Warehousing > December 2005 > Loading Lata from Excel spreadsheet
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Loading Lata from Excel spreadsheet
|
|
|
| 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
Harsh
| |
|
| 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
"Harsh" <Harsh@discussions.microsoft.com> wrote in message
news:102B7C8A-9706-4BB5-AA67- 25B9CE0BDCAB@microso
ft.com...
> 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
> Harsh
| |
| Peter Nolan 2005-12-10, 11:23 am |
| 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
|
|
|
|
|