I have create a query in VBA, opens ADO connection and displayes in the Excel.
And also i have created a user column besides the query results so the user inputs the name and submit, when submitting i need my excel to write to the SQL table.
How could this be possible in effecient way?
Bookmarks