how do i transfer data from excel into access?

M

Michelle L

I really don't know anything about access, but my office is trying to
transition into access for some of our employee files. If I already have
some information on excel worksheets, how can I transfer that data to access?
 
J

John Vinson

On Mon, 9 Oct 2006 12:03:02 -0700, Michelle L <Michelle
I really don't know anything about access, but my office is trying to
transition into access for some of our employee files. If I already have
some information on excel worksheets, how can I transfer that data to access?
Click to expand...

File... Get External Data... Import, or File... Get External Data...
Link.

Note that Excel is a spreadsheet, a terrific one; Access is a
relational database. IT IS NOT A BIGGER VERSION OF EXCEL!

Just importing the data is a very tiny step. You will need to - almost
certainly - completely restructure the way the information is stored,
and - completely certainly - build all-new Forms and Reports to
display the data. The entire logical structure of the program is quite
different!

John W. Vinson[MVP]
 
M

Michelle L

Thanks for the info. I know that it is a totally different program and that
i will have to create almost everything new but there is so much info in
excel. I have one other question if anyone out there can answer: My office
keeps tracks of all our employees trainings and we would like to be able to
imput all the info from those traings and then be able to pull up lists of
training that a particular employee has gotten as well as which people have
taken a particular course. Would access be the best program to use or is
there something else that you might suggest?
 
J

John Vinson

Thanks for the info. I know that it is a totally different program and that
i will have to create almost everything new but there is so much info in
excel. I have one other question if anyone out there can answer: My office
keeps tracks of all our employees trainings and we would like to be able to
imput all the info from those traings and then be able to pull up lists of
training that a particular employee has gotten as well as which people have
taken a particular course. Would access be the best program to use or is
there something else that you might suggest?
Click to expand...

Unless you're talking about training for hundreds of thousands of
employees, Access should be just fine for this purpose (much better
than Excel). In fact, Students and Classes is a very typical
introductory training example for building Access databases.

John W. Vinson[MVP]
 
Top