Problem of imorting a datatable from one database to another

[rajath]

Hi All,



I am Using two password protected databases in my project, Say DB1 and DB2. Password for DB1 = 1 and password for DB2=1.

I need to import datatable say FirstTermExam present in DB1 and to store it as TempFirstTermExam in DB2. I have used this query:

INSERT INTO TempFirstTermExam
SELECT * FROM FirstTermExam IN 'C:\aa\ DB1 .MDB'

but i am getting error as "not an valid password".

i am using msacess2003 mdb

[maximus]

After Reading you Thread I have assumed that you have the following Requirement
1) You have two databases both password protected
2) You want to open one of them and append the data in a table in that database to a table in the current database.

This is what I have Done:
1) I have a Database called Sample3.mdb
2) Password protected, Password is hh
3) I will import the table Order in my Currentdatabase as Order_list
4) Close Sample3.mdb.
5) Append the data in Order_list into a Table Called TempOrder in my currentdb.
6) Delete the table Order_list imported from Sample3.mdb

Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
'////////////////////////////////////
'Written By Siddthartha Majumdar 05/08/2010
'To open a password protected datase and import a Table
'//////////////////////////////////
Dim strSQl As String
'Opening the database with the password
Set db = OpenDatabase("C:\Sample3.mdb", False, False, _
";pwd=" & "hh")
'Importing the Order Table into the Database as Order_List
DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\Sample3.mdb", acTable, "Order", "Order_list", False
'Closing the database
db.Close
'An Insert Query to insert The data from Order_list to my TempOrder Table in Current Database
strSQl = "Insert Into TempOrder Select * From Order_List"
'Executing the Sql Appending the Data
CurrentDb.Execute strSQl
'Deleting the Table Order_list
CurrentDb.TableDefs.Delete "Order_list" 'If Order_List is there the table is Deleted

Exit_Command1_Click:
Exit Sub

Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click

End Sub

Note: Please replace the mdb File Name, Table Name with the ones in you database.

Mark the thread solved if this solves your problem

[maximus]

is your problem solved if yes mark the thread solved.

[maximus]

is your problem solved.