Import .txt file into the table

Question

Hi Team

SP_Table

Name    Used Date      Desc    Specification

aaaa    12-03-2013    laptop   xxxx

bbb       13-04-2012   Comput   yyy   In this table we have around 10000 rows

,Now in .txt file we have only Name Colum around 6000 rows remaining colums null also no prob  i want to import this .txt file data into Sp_table could you any please suggest how can i import his .txt file data into the table.

Regards

Subu

---

subu

Answer 1

Hello,

the easiest way to do using data import export wizard in sql server, right click on the database where you want the table to be. and go to tasks---Import data. the source to flat file source and give path to this text file (you will have fiddle around to set your column delimiter and input data) and create the table if I not exits ir choose from the drop  down  in your destination..

Refer this more explanation..http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/title-12

---

Hope it Helps!!

Answer 2

Hi Thanks for your reply..

But my prob is allready table has having some data around.10000 rows.

I have to import this new text file data into the table, but in the .txt file having only one colum how can we mapping this colum to the table col that is prob here.

Can you please suggest me

Regards

Subu

---

subu

Answer 3

that's fine, you should still be able to append the new rows to the existing table data.

Refer to link I  provided above. in the destination page, choose your table from the drop down and  go to "Edit Mappings"  at the bottom, you should then see an option to "Append rows to the table" check that one and also, should be able to map the one column with the column in your table there. As long as your unmapped columns are Nullable, it should work just fine.

once done, you can preview it to make sure it looks alright before you proceed further...

---

Hope it Helps!!

Answer 4

it was completed thanks for your help..

---

subu