I can currently access a table from Access with VB but can figure out how to execute the macro in ACCESS from VB6.0. The Macro will then import data from a txt file into the correct table. Here is the code I currently have. Please help. Like I said, this will get the table I need, but I need to access the Macro instead of the table.
Private dbDatabase As Database
Private dbTable As Recordset
Private dbWorkspace As Workspace
Private Sub cmdImport_Click()
Set dbWorkspace = DBEngine.Workspaces(0)
Set dbDatabase = dbWorkspace.OpenDatabase("I:\My Folder\Provider Member Filter\Kelsey-Seybold.mdb")
Set dbTable = dbDatabase.OpenRecordset("Caremark", dbOpenTable)