Is there any difference between executing a SQL command, based on user input in a spreadsheet, from Excel VBA to modify records in an Access table and loading an Access table into a recordset, modifying the recordset, and then updating the DB? Right now I'm using dbs.Execute SQL COMMANDS for deletes and inserts, and it works fine, just wondering if there'd be any point in using Recordsets instead. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL & DAO
- Thread starter bmoremu
- Start date
TonyJollans
Programmer
Hi bmoremu,
I would stick with what you are doing. You don't have anything to gain by loading a RecordSet and doing yourself what Jet is now doing for you, most likely far more efficiently.
Enjoy,
Tony
------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.
I would stick with what you are doing. You don't have anything to gain by loading a RecordSet and doing yourself what Jet is now doing for you, most likely far more efficiently.
Enjoy,
Tony
------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question