S
sam
Hi All,
How can I make multiple data for the same column in excel go in access.
eg: There is a button "Submit" on the excel sheet that exports all of the
student data at once in the database.. I want to insert all this data in a
seperate row.. all at once..
Here is what My excel table looks like:
Student_ID Subjects Grades
123456 Eng A
123456 Hist B
123456 Math B+
123456 Bio B-
So, once we click "Submit" I want the the data displayed above to go in
access, Each student data should go in a new row(basically access table
should look exactly the same as the excel sheet above)
here is what I have for recordset(part of my code):
With rs
.AddNew
.Fields("Student_ID") = Range("A3").Value
.Fields("Subject") = Range("B3").Value
.Fields("Grades") = Range("C3").Value
.Update
End With
r = r + 1
Thanks in advance
How can I make multiple data for the same column in excel go in access.
eg: There is a button "Submit" on the excel sheet that exports all of the
student data at once in the database.. I want to insert all this data in a
seperate row.. all at once..
Here is what My excel table looks like:
Student_ID Subjects Grades
123456 Eng A
123456 Hist B
123456 Math B+
123456 Bio B-
So, once we click "Submit" I want the the data displayed above to go in
access, Each student data should go in a new row(basically access table
should look exactly the same as the excel sheet above)
here is what I have for recordset(part of my code):
With rs
.AddNew
.Fields("Student_ID") = Range("A3").Value
.Fields("Subject") = Range("B3").Value
.Fields("Grades") = Range("C3").Value
.Update
End With
r = r + 1
Thanks in advance