Updating SQLServer from excel using VBA

Hi,

I have been trying to update the contents of the attached excel 2003 file using VBA to a SQL Server express database hosted on a server.

The database details are as follows:

ODBC;DSN=CFXWMS;UID=cfx;;APP=Microsoft Office 2003;WSID=LD04;DATABASE=CFXWMS

Tables to be updated are ORDERHEADER.REFORDERNO, ORDERHEADER.TRACKINGNO which match the attached excel file.

Basically I want the VBA to look for the ID in column A (REFORDERNO) and update the tracking information column B (TRACKINGNO) from the excel file to the ORDERHEADER table of the CFXWMS database.

Any help is appreciated.

David