Hi,
I have Netezza database which runs on SQL query and have many tables in it.
I want to build an access file which will work like:
Form - Click button and then it will connect to netezza and run a SQL query(Picks data from one of the SQL tables with certain condition) .The result from that query should be stored in Access table.Then exporting that table data to excel. Rest that excel will run a macro upon getting the data updated.
All this in one macro click..
Can anybody please help me with a VBA code for the same
I have Netezza database which runs on SQL query and have many tables in it.
I want to build an access file which will work like:
Form - Click button and then it will connect to netezza and run a SQL query(Picks data from one of the SQL tables with certain condition) .The result from that query should be stored in Access table.Then exporting that table data to excel. Rest that excel will run a macro upon getting the data updated.
All this in one macro click..
Can anybody please help me with a VBA code for the same
Last edited:
