trying to insert records into SQL database

[FunkyDexter]

I had a similar problem and Si pointed me at a post of JMcIlhinney's. That might be your problem


edit> also, as an aside, you don't need to open and close your connection each time you run the insert. It would be more efficient to open it before the loop and close it afterwards.

[scootsah]

Thanks for the suggestion. I found that setting & changed it as described, but still no luck. I don't think this could be the problem anyway, as I was able to manually add a record into the table & that one persisted. Since this is my first time around, perhaps it is something more basic, like perhaps I'm not connected to the correct table or some such thing.

Here's an example of what one of the cmd.CommandText looks like:

"INSERT INTO StampStaticInfo (ScottNo,Denomination,Description) VALUES ('2',0.10,'Washington - black')"

Any suggestions?