import excel into a query

[madrappin]

Is it possible to import a spreadsheet from excel as a query, and then have the query update a table based off of the primary key? Or maybe there is an easier way, I just need to get some data from a spreadsheet into a table that I already have created, without losing any of the data thats already there. thanks

 

[SuicidED]

You could link/import the spreadsheet and then use an append query to add the data to your table.