>>Try the bulk copy program... BCP.
>
>I thought of that, but I don't want to have to reindex after every load. I already have 900,000+ records in there as it is. bcp doesn't use indexes.
BCP has two modes: fast and slow. If the table has existing indexes, using BCP to import data will update the indexes. It will also cause every new row to be logged.
-Mike