0
Answer

C# to Create Access Query

Photo of richard smith

richard smith
11y
2.3k
1
Can you use this syntax to open an access database - create a query - then save the query - then close the database?
 
 [code]
Microsoft.Office.Interop.Access.Application accessApp = new Microsoft.Office.Interop.Access.Application();
accessApp.OpenCurrentDatabase(@"C:\\Test\\Test.mdb", false, "");
accessApp.DoCmd.RunSQL("Select * FROM tableData");
accessApp.DoCmd.Save(AcObjectType.acQuery, "All");
[/code] 
 
Next Recommended Forum