Import data from text file in SQL Server

Last Post 12 Mar 2012 06:50 AM by Kevin frazier. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
VikramTyagi
New Member
New Member

--
15 Feb 2012 07:56 AM
Hello Everyone, I want to import data from text file in SQL Server. SO I want to know whether any option to perform this task. Please give me appropriate answer. Thanks in advance!
rm
New Member
New Member

--
15 Feb 2012 12:22 PM
You can use bcp, bulk insert or ssis. Books online has details for all of those.
gunneyk
New Member
New Member

--
15 Feb 2012 01:29 PM
Another option is to use the Import Wizard as well. Right click on the database in the SSMS and choose "Tasks" then "Import Data".
Kevin frazier
New Member
New Member

--
12 Mar 2012 06:50 AM
Rick clicking and using the import/export wizzard it the easiest way. You can always save the process and have it run as a SSIS package as well.
You are not authorized to post a reply.

Acceptable Use Policy