Create tables from flat file

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  March 19, 2008 at 4:34 am

  #69743

  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]

• Jeff Moden

  SSC Guru

  Points: 1004339

  More actions

  March 19, 2008 at 5:58 am

  #791385

  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)