Importing some excel data to Access table

[jlwood44]

I'm trying set up a new ACCESS database. (and I am a relative newbie) with a
fair amount of EXCEL experience. I have some info on EXCEL worksheets, and
would rather not retype the info. I am looking at using the first 5 columns
of each EXCEL worksheet to be part of an ACCESS table - fields 2 thru 6.

I created a table in ACCESS with about 10 fields withfield #2 being last
name. I then tried to import from an EXCEL worksheet. When I did this it
seemed to take my complete worksheet to ACCESS and wanted to create a new
table.

Please help.

 

[Joe Fallon]

I recommend you do create a new table in Access.

The key concept is to get the raw data out of Excel and into Access "by hook
or by crook."
Because once it is in Access you can do anything with it. Access has data
types for fields and Excel does not.

Once the data is in your new table you just write a query and Append it to
your existing table.
The Append query will allow you to only use those fields that you want and
will also let you modify the raw data before loading it into the existing
table. (e.g. Combine or truncate fields before running the append query,
etc.)

Good luck.

 

[jlwood44]

If I'm importing from 3 worksheets,doesthis mean I create 3 'new' tables?

Being a while since I worked with my other ACCESS database, how would I then
make a Querry that would collect the data from the tables.

In advance, thank you for the help.

 

[jlwood44]

I'm using Access 2000 at home and Access 2003 at school. How much of a
problem will this be?

 

[jlwood44]

The info coming on the import is name info. How am I going to set up test
scores? Am I going to link with the first table and create another table?
What happens with the students that I have in 2 classes, or I had in class
last year? Fortunately each student besides their name has a student ID.

Sorry if I'm looking like a total Newbie.

Thanks for the help.