| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updateing Access DB
Can someone point me in the right direction to write the VBA to "Append" and
data table in Access.. I have the code to connect...and I have the SQL Statement...just not sure how to write the code to "Append" the data Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Updateing Access DB
Hi
See http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dstiefe" wrote in message ... Can someone point me in the right direction to write the VBA to "Append" and data table in Access.. I have the code to connect...and I have the SQL Statement...just not sure how to write the code to "Append" the data Thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Updateing Access DB
Thank you..
Do you have a similiar link to the code that would "delete" a set of records from a table...based on a date for example? thank you again! "Ron de Bruin" wrote: Hi See http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dstiefe" wrote in message ... Can someone point me in the right direction to write the VBA to "Append" and data table in Access.. I have the code to connect...and I have the SQL Statement...just not sure how to write the code to "Append" the data Thank you . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Updateing Access DB
No sorry, only one to get data from Access
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dstiefe" wrote in message ... Thank you.. Do you have a similiar link to the code that would "delete" a set of records from a table...based on a date for example? thank you again! "Ron de Bruin" wrote: Hi See http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dstiefe" wrote in message ... Can someone point me in the right direction to write the VBA to "Append" and data table in Access.. I have the code to connect...and I have the SQL Statement...just not sure how to write the code to "Append" the data Thank you . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subject: Updateing Access DB
You need a delete query to do this. See this:
http://www.databasedev.co.uk/delete_query.html -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Updateing Information | New Users to Excel | |||
| Updateing a workbook from another workbood | Excel Programming | |||
| Updateing worksheets when openening workbook | Excel Programming | |||
| Updateing formulas | Excel Worksheet Functions | |||
| Pivot Not Updateing | Excel Worksheet Functions | |||
Linear Mode
