Update a Database Using Excel

[Guest]

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

 

[Fredrik Wahlgren]

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_d...s_(ADO)_using_VBA_in_Microsoft_Excel/425.html
http://www.vbcity.com/forums/topic.asp?tid=96104

/Fredrik