bjoshi
06-02-2011, 09:16 PM
I have a access file at "c:\temp.mdb" its password protected, lets say the password is "xxx".
The mdb file has 2 tables, table1 and table2 both tables have the same variables,
1.Autonumber
2.FirstName
3.LastName
4.Date
I have an excel sheet with 2 columns (Firstname,LastName) and there is just 2 rows of data in it starting from range(A2 to B3)
I want the values of the first row (A2:B2) (FirstName,Lastname) to be updated in Table1 of the mdb file.
Then, I want the values of the second row (A3:B3) (FirstName,Lastname) to be updated in Table2 of the mdb file.
Also, in both tables (table1,table2) I need the current system date and time to be updated in the 4th variable "Date".
After this, I need to get back the complete data (Autonumber,FirstName,LastName,Date) from both the tables in ranges (A5 to D6).
This sounds lame, but I didnt want to start 2 threads one for import and other for export. Also I am using Office 2003, will this be different for Office 2010?
Thanks,
bjoshi
The mdb file has 2 tables, table1 and table2 both tables have the same variables,
1.Autonumber
2.FirstName
3.LastName
4.Date
I have an excel sheet with 2 columns (Firstname,LastName) and there is just 2 rows of data in it starting from range(A2 to B3)
I want the values of the first row (A2:B2) (FirstName,Lastname) to be updated in Table1 of the mdb file.
Then, I want the values of the second row (A3:B3) (FirstName,Lastname) to be updated in Table2 of the mdb file.
Also, in both tables (table1,table2) I need the current system date and time to be updated in the 4th variable "Date".
After this, I need to get back the complete data (Autonumber,FirstName,LastName,Date) from both the tables in ranges (A5 to D6).
This sounds lame, but I didnt want to start 2 threads one for import and other for export. Also I am using Office 2003, will this be different for Office 2010?
Thanks,
bjoshi