Excel To Access: Help with getting a range data from excel to acce

S

sam

Hi All,

How can I transfer a Bock of data to Access from excel by clicking a Submit"
button?

eg: There is a "Submit" button on the excel sheet that exports all of the
student data at once in the access database.. I want to insert all this data
in access at the same time.

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 data displayed above to go to
access, I know how to code a button to transfer data from excel to access,
BUT I dont know how to get a block of data from excel go to access at.

So basically It should look the same in access like it looks in excel
(transfer the entire data shown below in access at the same time).

Student_ID Subjects Grades
123456 Eng A
123456 Hist B
123456 Math B+
123456 Bio B-

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top