Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL UPDATE for "edited" records
So for the first time I am using the external data functions of Excel to
overlay Access, the reason is that everyone here is afraid of Access... I have today figured out how to get the info into Excel and back into Access, but what I am currently doing is deleting the table in Access and replacing everything with the range from Excel. Can I get some feedback on an improved way to handle this? I would like to just Update or Append for items that were edited in the Excel file after the data was imported on open. The table residing in Access is 42 Columns and over 25000+ rows in length. Would I use something like Private Sub Worksheet_Change(ByVal Target As Range) ??? This seems cumbersome, does anyone have some suggestions? -Steven M. Britton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |