External Database Usage

[Sandeep]

hello sir,

I am using

Insert into <tablename1> in " location " select * from
<tablename2>

but the problem is how to specify the password if the
tablename1 at location specified in IN clause has password
on it

Plz send me some example

 

[Tim Ferguson]

Insert into <tablename1> in " location " select * from
<tablename2>

but the problem is how to specify the password if the
tablename1 at location specified in IN clause has password
on it

You can use as much of a connection string as you want in the square-
bracket format; check help files for the IN clause:

.... IN "" [Database=h:\mydata\myother.mdb; pwd=shoes; uid=Eric;]

This is off the top of my head, and you may need to experiment a bit. There
is more information in vba help: look up the Connect property of the
TableDef object.

Hope that helps


Tim F