urgent..excel to access

Hi

I have a file in excel whose data is a combination of columns from multiple tables. I want to import the excel sheet into access whereby while importing i want that the values of excel sheet columns should go to the mutiple tables automatically.

is it possible? if yes how? if not then how can i do it?

thanks

im sorry, cant help you, but maybe you can help me,seeing as your working with excel.

im using excel as a datasource. which is working fine, im connecting to the excel file and displaying the data on an asp page..

but for some weird reason some of the values in the excel table arent being read. the asp page displays the cell as empty.. while the cell is not empty.

sometimes this problem is being solved by putting a ' charackter in fron of the text in the excel cell... but not always...which is evn more weird.

any help
thanks