March 19, 2008 at 4:20 am
Dear All,
I had recieved an excel sheet from one of my clients which contains nearly 300,000 of rows. I want them to be imported into a test database and i want to normalize the database. As I dont have enough time and inorder to save time can you suggest me some tools which would build up some tables from the existing data (just like tools ->analyze->table in microsoft access. Depending on the suggestions made by the tool i would study and if required i will normalize again.
Thanks & Regards
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
March 19, 2008 at 5:58 am
Cross posted 5 times... if you answer, recommend you use the first URL below...
http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx
http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx
http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx
http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx
Chandra... this type of cross posting just ticks people off and spreads resources. Good number of us monitor all the forums... someone will answer... if they have time. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2008 at 9:45 am
Linking with Excel
Linked Server:EXCEL_EXPORTER
Provider: Microsoft Jet 4.0 OLEDB Provider
Product Name: Excel
DataSource:
Provider String: Excel 8.0
Note: Check "Distributed Transaction Coordinator" is started in Service.msc.
Select * From EXCEL_EXPORTER...Sheet1$
Insert Into EXCEL_EXPORTER...Sheet1$(F1,Latheesh)
Select 2,'Megh'
April 14, 2008 at 12:29 pm
ssis
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply