PC Review


Reply
Thread Tools Rate Thread

Excel To Access: Transfer multiple rows from excel to access

 
 
sam
Guest
Posts: n/a
 
      20th Jan 2010
Hi All,

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

eg: I have designed a "Submit" button on the excel sheet that exports all of
the
student data into access in a single row... BUT I want to insert all this
data
in access in seperate rows.

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.
NOTE: it should look exactly the same in access, each row in a seperate row
in access

What I have now: I can get this data into access but all in one single row,
which looks like this:

Student_ID Subjects Grades Subjects2 Grades2 Subjects3 Grades3
123456 Eng A Hist B Math
B+

What I want:

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

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, each in
new row).

Hope I made it clear

Thanks in advance


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel To Access: Transfer multiple rows from excel at the same tim sam Microsoft Excel Programming 2 22nd Jan 2010 09:57 PM
query return multiple rows to autofill multiple rows on continuousform p-rat Microsoft Access Form Coding 0 18th Feb 2009 11:33 PM
Multiple rows within multiple rows =?Utf-8?B?QWNlOXg=?= Microsoft Access Forms 3 9th Sep 2005 10:04 PM
Importing CSV file into single column/multiple rows vs. multiple rows/single column bjorgenson@charter.net Microsoft Excel Discussion 3 27th Jun 2005 08:25 PM
inserting multiple blank rows on alternate rows & multiple formulas bob green Microsoft Excel Worksheet Functions 3 21st Sep 2003 06:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:36 PM.