Sunday, February 17, 2013 5:21 AM
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.
- Changed Type Kalman TothMicrosoft Community Contributor, Moderator Sunday, February 17, 2013 7:47 AM question
Sunday, February 17, 2013 5:28 AM
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!!
- Edited by Stan210 Sunday, February 17, 2013 5:33 AM
- Proposed As Answer by Kalman TothMicrosoft Community Contributor, Moderator Sunday, February 17, 2013 7:51 AM
- Marked As Answer by Iric WenModerator Monday, February 25, 2013 9:36 AM
Sunday, February 17, 2013 5:35 AM
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
Sunday, February 17, 2013 5:54 AM
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!!
Sunday, February 17, 2013 6:28 AMit was completed thanks for your help..