Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to write code (in Excel's Visual Basic)
that accesses an Access database and deletes all current records? I want all of this to happen when the user hits a button that says "update". What I am trying to accomplish is to download the existing data out of Access, edit the data in Excel, remove the old records in Access and import the updated records from Excel. The only part I can't figure out is how to delete the existing records in Access so that I don't have duplicate enrties when I upload the refrshed data from Excel. Can anyone help? I'd be so grateful! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how i can do programming in MS Excel.? | Excel Worksheet Functions | |||
ADO programming in Excel-VBA | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Excel Programming in VB | Excel Programming | |||
Excel Programming in VB | Excel Programming |