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 spreadsheet, if possible i
like to keep the existing data in access and over right it with a
blank cell.
The spreadsheet 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 :)
FSt1 - 25 Jun 2007 19:57 GMT
hi
no script needed.
declare your data a named range.
Hightlight your data. Insert>name>define>Name it>ok
Then go to access. link the named range to access as a table.
Then write an undate query to update the access table that the data came out
of.
this way you can download from table one, make changes in the excel table
then
update access with access from the excel table.
just a suggestion
regards
FSt1
> Any suggestions?
>
[quoted text clipped - 10 lines]
>
> Thanks :)