View Single Post
  #2   Report Post  
Anthony Slater
 
Posts: n/a
Default

Shouldn't you be using a link-table in Access?

"Reigning in Seattle" wrote:

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.