Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Access table with a range from Excel, | Excel Programming | |||
Updating Access Database from Excel need help | Excel Programming | |||
Updating Access from Excel Macro | Excel Programming | |||
Access records updating from Excel. | Excel Programming | |||
updating Access table with Excel data | Excel Programming |