Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
- From: Chris <stealthyc@xxxxxxxxx>
- Date: Mon, 25 Jun 2007 17:59:57 -0000
Any suggestions?
Some of these rows only need a few columns updated, and others need
all of them updated. If possible if say row 800 column 'S' is filled
in the access DB but is blank on the excel spread***, if possible i
like to keep the existing data in access and over right it with a
blank cell.
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?
Thanks :)
.
- Follow-Ups:
- Re: Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
- From: Stephen Howe
- Re: Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
- Prev by Date: RE: Inserted Identity Values in SQL 2005
- Next by Date: Re: appendChunk method resulting in incorrect data
- Previous by thread: Rounding error while saving a recordset as XML
- Next by thread: Re: Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
- Index(es):