Dim myOleCommand As OleDbCommand Dim myConn As New OleDbConnection("C:\Enrollment Form\EnrollmentApp\EnrollmentApp\EnrollmentDB.mdb") myConn.Open() Dim strCommand As String strCommand = "Insert into tmpStates (StateShortName) values('Chokka')" myOleCommand = New OleDbCommand(strCommand, myConn) myOleCommand.ExecuteNonQuery() myConn.Close()
|Access 2013 - Export multiple query/table from access to one excel workbook with formatting||2||24|
|Link Excel Spreadsheet to Access, not using Transferspreadsheet||5||26|
|Prevent use of Microsoft Office application||9||53|
|Exit the loop||4||31|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!