N
Nigel Findlater
Hallo
I am trying to insert data from one database into another. This works fine when there is no database passwor
insert into Tst_TestNew select Tst_Test.* from Tst_Test in 'D:\Import.mdb
But I have a problem when the database is password protected. I tried the following but without success
INSERT INTO Test_Value
SELECT [Test_Values].
FROM [;pwd=xxx].[Test_Values] IN 'D:\Test.mdb'[;pwd=xxxx]
Where Test.mdb has a passowrd xx
Any ideas..
Nigel...
I am trying to insert data from one database into another. This works fine when there is no database passwor
insert into Tst_TestNew select Tst_Test.* from Tst_Test in 'D:\Import.mdb
But I have a problem when the database is password protected. I tried the following but without success
INSERT INTO Test_Value
SELECT [Test_Values].
FROM [;pwd=xxx].[Test_Values] IN 'D:\Test.mdb'[;pwd=xxxx]
Where Test.mdb has a passowrd xx
Any ideas..
Nigel...