sql to database

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

Bre-x

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!!!!
 
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
 
Back
Top