Shows how to pull data from programmatically from Microsoft Access and put to Excel. Access is never opened - the code connects to access and uses SQL to pull the data.
I need this same procedure but to put data from an excel spreadsheet into a table access via a form but I have no knowledge of vba ... Could you help me please? This application is only for reports of several months ... but every time I want to import a new worksheet, I will use this form to import Excel spreadsheet to access, thanks!
I need this same procedure but to put data from an excel spreadsheet into a table access via a form but I have no knowledge of vba ... Could you help me please? This application is only for reports of several months ... but every time I want to import a new worksheet, I will use this form to import Excel spreadsheet to access, thanks!
Rafaeljunio2004 3 months ago