urgent! excel to access

[monika]

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 multiple
tables automatically.

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

thanks

 

[amby]

try exporting as is to access then use
sql to split the data as required , you could also create a
query to automate the splitting
hth