Re: Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?

The spread*** is a export of the access DB, changes were made/merged
from other spreadsheets so the Unique ID is the same and in column A.

A script suggestions to complete this?

Probably in VBA (Excel Basic).
You would be constructing an SQL Update Statement on-the-fly examining each
cell and appending more SQL for each non-empty cell. You need something to
stick on the WHERE clause. After that, do a Connection Execute, for each
line in turn.

That is how I would tackle it but since I dont work in Excel BASIC, I dont
know if it is possible.

Stephen Howe



.