Getting information out of linked Excel worksheets

[amfroehlich]

I have link a couple of Excel worksheets to Access. Now i want to start pulling some of the information into their repective access table that I have built.

How do I tell Access to pull this cells information and place in Events table and pull this other information and place it in the manufacturers table?

Thanks,

Aaron

 

[Norie]

You could create append queries using the linked files, which Access treats just like a table.

Or you could import from the files into existing queries.

Both options require that data types/field names in the Excel files match those in your table.