I need to pull data from Excel spreadsheet into Access

[bhavankars]

I have an Excel workbook, with one sheet having data (with column headers/field names).

I have an Access database table with the same names.

How do I link them and pull data from Excel into Access table?

-Also can I have more than one table in Access and still pull data into multiple tables?

 

[Norie]

What exactly do you want to do?

You could import/link the Excel workbook into Access using File>Get External Data>Import.../Link Tables...

If you Link the spreadsheet then Access will treat it as a table, if you import it Access will create a new table.

Either way you could then use an append query if you want to add the data from Excel to a table.

 

[bhavankars]

Thanks for replying.
I am trying to import data from Excel spreadsheet into an already defined Access table by using a macro -Transferspreadsheet action