Heh... neither... use BULK INSERT from T-SQL 😉

Change it... it's worth it in terms of performance. 😉

Would you mind posting some data so we can help you accurately? Please see the following article for how to get really good answers quickly... seriously... read the article......

I know it's an older article, but I gotta say, nicely done, Kathi! Great examples for folks that don't know.

Interesting problem and thanks for the feed back...

Now, what's an "SQLDataAdapter"??? :blink:

It's great code! But only if you're inserting 1 row at a time from the GUI. 😉

Chaohua Wang (10/5/2006)

---

This error may not cause your system down. The database tempdb is automatically shrunk normally. There is an "bug" here. We may get an error message if a...

The numbering system is flawed to begin with... 003.31 should not be the child of 003.3... they're both at the same "level" in legal numbering. If 003.31 is the...

Michael is quite correct... if the 1099's end up becoming your main income or they exceed certain amounts, you MUST pay estimated quarterly taxes... do consult a good accountant! ...

Yup... easy to do if no foreign keys... of course, if these IDENTITY columns are being used as the PK...

Yeah, uh-huh... what...

Favorite temp table name... #MyHead 😀

Heh... "It Depends" 😉

Table size went up because instead of just storing text pointers, you are now storing the data itself... that, of course, takes extra room. In fact, you now have...

Exporting to spreadsheet is "Death by SQL"... if someone opens it, BOOM! Process in SQL is dead... period.