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 |
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
 Posted - 2006-01-28 : 17:11:31
|
| Hi,I'm working on a website where a user can upload a file with some data. The data is parsed into in memory objects and now I'm wondering how to insert this into the database.The bulk insert methods I've seen all seem to require that the data is in a file on the same machine as the db. How can I bulk insert from memory?Also, if data is sent to the db as a CSV, then what is the standard procedure for stopping commas in the data being mistaken for commas which delimit the data?Cheers, XF. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-01-28 : 17:42:45
|
| http://weblogs.sqlteam.com/billg/archive/2006/01/24/8855.aspxcould be of some help, there is some code that creates a text file and bulk inserts it into a table, if I remember right.rockmoose |
 |
|
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
Posted - 2006-01-28 : 18:08:53
|
| Hi there, that appears to be using .net 2.0. Unfortunately I'm still using 1.1.But goodness, SqlBulkCopy would have done the trick. |
|
|
|
|
|
|
Best way to bulk insert from memory