sql query to connect to base with password

[darazbox]

hi,

I have question.. how to connect to access database using SQL statment?
I have query like this:

INSERT INTO export_klient IN 'D:\\base\\test1.mdb' SELECT * FROM klient
WHERE (card=100)

test1.mdb have set password...

how to do it?

thanx...

regards
da1

 

[MacDermott]

You'll need to set up a separate ADO connection to do this; include the
password in the connection string.

 

[darazbox]

ok, thanx,
but how to do it?
I need to execute query from one base, and put data to another
database... something like in example in my post.. so there are no
possibility to use standard SQL query to do this?

thanx
da1

 

[MacDermott]

Teaching you to use ADO is a bit wider than the scope of a newsgroup post.
You will, indeed, use a standard SQL query for the syntax, but you'll need
some more code to execute it - not just CurrentDB.Execute or DoCmd.RunSQL...

 

[darazbox]

MacDermott napisal(a):

Teaching you to use ADO is a bit wider than the scope of a newsgroup post.

sure it is I don't want to..

You will, indeed, use a standard SQL query for the syntax, but you'll need
some more code to execute it - not just CurrentDB.Execute or DoCmd.RunSQL...

ok, it is answer, I was thinking to do it in simple way thru SQL
query.. but I see it is not that simple..

thanx for help
regards