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 |
|
Amjath
Yak Posting Veteran
66 Posts |
 Posted - 2007-01-23 : 22:55:27
|
| Hi All,i like to make bulk insert in MS Access by programmatically using c#.in the loop in concatenate the query just like this INSERT INTO Station3BResult(RadioMac, TestID, [Value], ChannelUsed, PowerUsed, BucketResult) VALUES('00301A1F55BE', 'ALL_3B_00', '12.900000', '6', '14', 'Silver');INSERT INTO Station3BResult(RadioMac, TestID, [Value], ChannelUsed, PowerUsed, BucketResult) VALUES('00301A1F55BE', 'ALL_3B_01', '10.700000', '153', '14', 'Silver');INSERT INTO Station3BResult(RadioMac, TestID, [Value], ChannelUsed, PowerUsed, BucketResult) VALUES('00301A1F55BE', 'ALL_3B_02', '9.750000', '161', '14', 'Silver');when i try to Execute this query it show some error like thisCharacters are present after terminated string something like this.plz help me-Amjath |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-24 : 04:38:49
|
| 1. run this direct in access and prove the SQL code actually works.2. split this into 3 seperate queries, and then execute each via C#3. then combine any lessons learnt from 1+2 and improve the starting code. |
 |
|
|
|
|
|
|
|
Bulk Insert in MS Access