F
franandanna
Hi
I have 4310 update statements to run on an MS Access database. If I was
using Oracle, I'd just run sqlplus and do @updates.sql to run a text
file of the update statements.
Is there some equivalent with MS Access?
I have tried pasting 500 update statements at a time into the MS Access
SQL Query window, but they seem to get considered all together as a
single statement. (Maybe there's a statement delimiter, something like
";" but not ";") that would separate the statements so I could just do
chunks of 500 updates at a time.
Thanks for any help
I have 4310 update statements to run on an MS Access database. If I was
using Oracle, I'd just run sqlplus and do @updates.sql to run a text
file of the update statements.
Is there some equivalent with MS Access?
I have tried pasting 500 update statements at a time into the MS Access
SQL Query window, but they seem to get considered all together as a
single statement. (Maybe there's a statement delimiter, something like
";" but not ";") that would separate the statements so I could just do
chunks of 500 updates at a time.
Thanks for any help