Importing from Excel

I am trying to import data from Excel spreadsheet into "Donar" database in Access.
I have 3 tables in Access namely"individual","Business" and "foundation".My Excel
spreadsheet has all the donars(individual, business and foundation) listed in a mixed way
and they not not categorized.ie, first 5 rows would be individual,next 3 would be business and
next 2 rows would be individual and so on.Does anyone know how I can import this
mixed data into 3 seperate tables into access on a row by row basis?Thanks for helping with this.

I think you will find it alot easier to filter your excel sheet to just Individuals first, copy those items into a new sheet and then import that sheet into your Individual table and then doing the same with Business and Foundation.

Otherwise you will have to create a query to filter the data accordingly and then append to the appropriate table which would involve three queries, or one query where you change the filter each time before appending the records. They are other ways, but the first is the simpliest.

lwells