urgent! excel to access

  • Thread starter Thread starter monika
  • Start date Start date
M

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
 
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
 
Back
Top