Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richy
Starting Member
3 Posts |
 Posted - 2002-11-29 : 08:34:33
|
| I'm trying to find out how to import a file from a certain directory into my SQL Server database using T-SQL but can't find out how. Can anybody help?Visit the Football Predictions Leaguehttp://www.ukfpl.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-29 : 08:41:48
|
| Look at bulk insert or bcp (probably the easiest).You can also crate a dts package to do it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
richy
Starting Member
3 Posts |
Posted - 2002-11-29 : 08:53:19
|
| that bcp looks as though its what I need.Thanks a lot. Is there anything you don't know? :-)Visit the Football Predictions Leaguehttp://www.ukfpl.com |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-29 : 08:58:00
|
| >> Is there anything you don't know? Lots and lots.Fortunately 90% of the questions have turned up before and there's not that much you need to know to build systems (just when to use it).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Importing from CSV File