I know -- ADO is much better for many reasons, but for various political reasons I have to use DAO.
Anyway, I've written VBA/DAO code which inserts from a range to a SQL Server table one row at a time. It's cumbersome, because I have to slap together an INSERT INTO table (columns) VALUES (expressions) statement for each row, and it's slow, because I have to throw lots of INSERT statements at the database. I've even tried beginning and committing a transaction, but it's still slow.
There's GOT to be a way to do it in one shot, i.e., the reverse of the Range.CopyFromRecordset method. Isn't there?
Anyway, I've written VBA/DAO code which inserts from a range to a SQL Server table one row at a time. It's cumbersome, because I have to slap together an INSERT INTO table (columns) VALUES (expressions) statement for each row, and it's slow, because I have to throw lots of INSERT statements at the database. I've even tried beginning and committing a transaction, but it's still slow.
There's GOT to be a way to do it in one shot, i.e., the reverse of the Range.CopyFromRecordset method. Isn't there?
