hi! I need a program in vb that does this as soon as possible, I'd be very grateful if anyone could tell me how to do it:
the customer gives a table containing the old values and new values in an excel sheet which will be connected to an access table.
then the program checks for multiple new values for the same old value and after the user has corrected the values,
shows a form that takes a server and MSSQL database name and after connecting to and opening it, if a value in
it's table(like vouchers_no) is equal with a value from the access table in the oldvalue field, it replaces it's
value with the value of the newfield value of the same record.