View Single Post
  #1   Report Post  
Reigning in Seattle
 
Posts: n/a
Default Use Excel to make an update query to another database table?

I have a spreadsheet in Excel with information on it that I'd like to update
to a database table (outside of Excel).

I have been using Excel to pull database information in, and now I'd like to
use it to write data to the same table.

To this point I've just been copying the data into an Access table and
creating an update query.

Anyway to get Excel to do this?? Many thanks in advance.