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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-30 : 08:08:28
|
| Jaishankar writes "Hi,I am delveloping a telemetry data acquisition system in which online data will be storing in CSV/TXT file.My problem is how to load CSV/TXT file(which will be always receving data from telemetry system) to SQL SERVER table.And one thing i want to clear that i am able to load static file to sql table, could you give me the soluiton for storing online data.Regards-Jai'kar" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-11-30 : 08:13:03
|
| You can use BCP or DTS to achieve what you want. Refer to Books OnLine for details-----------------[KH] |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-04 : 07:51:55
|
| Open SQL server and right click your db, and choose import data, and follow the instructions.Basically your import file should point to your text file, while the destination should either be a table or create a new table yourselfafrika |
|
|
|
|
|
|
How to load online CSV/TXT file to SQL SERVER