External Database Usage

  • Thread starter Thread starter Sandeep
  • Start date Start date
S

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
 
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
Click to expand...

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
 
Back
Top