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

"Dmorri254" wrote in message
...
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



Yes. Here are two links with some code that you should be able to tweak and
use in your code

http://www.exceltip.com/st/Export_data_from_Excel_to_Access_(ADO)_using_VBA_i n_Microsoft_Excel/425.html
http://www.vbcity.com/forums/topic.asp?tid=96104

/Fredrik