View Single Post
  #1   Report Post  
Dmorri254
 
Posts: n/a
Default Update a Database Using Excel

Hi...I have several queries in excel so I have no trouble getting data from a
DB into excel. Is it possible to use a cell in excel to update a record in a
database? Example: A1 contains a number (12345) I want to use B2 to say match
the number in A1 to record 227 (the number I would type in B2 located in the
DB). That would update the databse so that when I go to the database, the
number 12345 will be matched to record number 227.

Thanx