Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing CSV file to Table in SQL Server

Status
Not open for further replies.
tomk

tomk

MIS
Jun 4, 1999
12
US
Does any one know what the easiest way to import a csv file to a table in SQL server?
 
Sort by date Sort by votes
The easiest way to import CSV data in SQLserver 7 is to use DTS services, especially if it is a one off import. DTS allows importing of data as well as data transformations if your data is not clean and/or needs converting.<br><br>Chris Dukes
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
204
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
206
carp
carp
Bill Doe
  • Locked
  • Question
PDO UPDATE too long to execute
Replies
1
Views
183
mikrom
mikrom
sal21
  • Locked
  • Question
SORT by part of filed 2
Replies
5
Views
213
2009luca
2009luca
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
147
harfri
harfri

Part and Inventory Search

Sponsor

Back
Top