By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Import from Excel into Access

P: 1
Access Naive - Help Needed

I am using Access 2003 and Excel 2003. My goal is to create a database for a school where each student's testing information can be stored and organized so that it can be pulled. Each teacher currently has their own Excel file, into which they have entered their student's data. However, for the purposes of other departments, they would like a database file where information can be culled and queries can be run (thus the need for Access).

I have multiple excel files, each with multiple worksheets. I would like to create an Access database using the information in the various Excel files (all of the files have the same column headings in each of the worksheet.. How do I make this happen? I am sure there is an easier way than I am trying. I do not know technical computer language, but I can follow directions, so ANY help would be appreciated.

Is there a way for multiple worksheet's and multiple file's data to be imported into an Access database?
Thank you!
Aug 20 '08 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,656
I've changed the title to something more sensible (conforms to site rules).

It's hard to answer the question though in this form.

What have you tried?

Is all the data in the same format?

Does the data include something that identifies its source (If the data comes from workbook A & sheet 3 are A & 3 in the data anywhere)?
Aug 20 '08 #2

Expert Mod 15k+
P: 31,656
The simplest concept (assuming no complications) is to copy and paste the data in after preparing the table that you want to store it all in.
Aug 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.