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 |
|
nebujacob2000
Starting Member
1 Post |
 Posted - 2004-03-01 : 01:07:04
|
| Hi I have got a csv file.I have to insert data from that file to a sql server data base.I'm using ASP as front end.I have to write some stored procs to insert the csv file to the data base.Pls help meThnxNebu |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-03-01 : 01:18:18
|
| Look up BCP and BULK INSERT in Books On Line.This should do the trick for you.Duane. |
 |
|
|
safigi
Starting Member
15 Posts |
Posted - 2004-03-01 : 04:18:48
|
Try this:SELECT *FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=F:\YourFilesDir;ExtendedProperties="Text;HDR=No;FMT=Delimited"')...[YourFile#txt]quote:
Originally posted by nebujacob2000
Hi I have got a csv file.I have to insert data from that file to a sql server data base.I'm using ASP as front end.I have to write some stored procs to insert the csv file to the data base.Pls help meThnxNebu
|
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
CSV file