Thread: sql to database
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
goshute goshute is offline
external usenet poster
 
Posts: 19
Default 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