Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql to database
Hi,
On MS Excell using VBA, I would like to send a sql command to and MS Access database "delete * from mytable where id=89" Thank you all!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql to database
Try This:
Create two objects in Access. 1. A Query that deletes the records from the table. 2. A Macro that runs the query. In Excel VBA Editor: 1. add a reference to your version of Access. 2. Inset this code that will start a new instance of Access and run the macro Sub RunAccessQuery() Dim appAccess As Access.Application Set appAccess = New Access.Application appAccess.Visible = True appAccess.DoCmd.SetWarnings False appAccess.OpenAccessProject ("C:\Test.mdb") appAccess.DoCmd.RunMacro ("MacroToDeleteRecordsWith89") appAccess.DoCmd.SetWarnings True appAccess.Quit Set appAccess = Nothing End Sub I did not test code, so be sure to test on a test application. Goshute |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql to database
Thank you!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
HELP: VBA Code to extract data from an SQL Server database and put it into Access Database | Excel Programming | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming |