September 15th, 2012, 04:20 AM
Export Excel to 2 tables Access ??????
I have a problem about INSERT INTO with 2 tables access.
My Excel file have a few paramater : StudentID, ClassID,ClassName,FirstName,LastName
My Access have 4 tables : Student, Class, Status,UserName
Student (ID Number, StudentID,ClassID, FirstName,LastName,UserName,Status,Date)
I want to insert data from excel to access with some requirement:
Field UserName show the user is logged in
Field Date show date/time which the user is logged in
Field Status is have 2 condition:
First, if you have updated StudentID, the Status is Active and the rest of parameter is update.
Second, if you do not update StudentID, you update all of them.
I hope everybody help me to resolve my lesson!!!!!!!!!!
Thanks for everybody!!!!!!!!!!
Click Here to Expand Forum to Full Width