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

I have been searching on the internet and am unable to find a close enough example to apply to my needs. Any pointers or suggestions are appreciated.

Thanks,

David

I'm still unable to update sql with the information on my xls file, has anybody out there ever tried to update an access db with linked tables to the sql server?

Something like:

Please Login or Register  to view this content.

Kyle,

Thanks for the response, when I ran the VBA it gave me the following error [Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied.

I appreciate your help,

David

That's your connection string, not mine - so I can't help you with that one I'm afraid. You might need to speak to whoever created the dsn on your machine or get a direct connection string without using ODBC

Sounds good, again thanks for your help.