Create tables from flat file
-
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] -
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Chandra...use the import and export Data and select the file u wanted and give the identifier and then the target database where u could give the table name also and run.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply