script to load a table with many values - ACCESS 2000

[L Mehl]

Hello --

When I update a data-driven application is there a way to update the db by
executing a script in ACCESS 2000 consisting of lines similar to

INSERT INTO table1 (col1, col2, col3) VALUES(col1val1, col2val1, col3val1)
INSERT INTO table1 (col1, col2, col3) VALUES(col1val2, col2val2, col3val2)
etc. ?

I want a method that I can send to the db admin to execute.

I would prefer not to have to build each INSERT command in VBA.

A Data Definition Query will only accept 1 row at a time. When I execute
that, it understandably becomes an Append query.

Thanks for any help,

Larry Mehl

 

[[MVP] S.Clark]

Docmd.RunSQL "INSERT INTO..."

 

[L Mehl]

Thanks Steve --

So, VBA is the only way.

Larry

Docmd.RunSQL "INSERT INTO..."

 

[Michel Walsh]

Hi,


Kind of seeing VBA is to Jet in Access what T-SQL is to SQL in MS SQL
Server.

You can use macros too. You can launch MSACCESS.EXE in a command line with
the switch /X to specify the run to start with the specified macro
(following the /X ).


Hoping it may help,
Vanderghast, Access MVP