Hello,
Someone to help with the excel macro to import data from access query to the excel sheet 1.
The access Query has been constrained with date parameter criteria as "Between[Date From] And [Date To]"
Note this date to be taken or referred from excel sheet 1 on cell H3 (date from) and H4 (date to)
A excel macro able to clear out excel sheet 1 on column A1 to F100 and paste the new access query data to the excel column A1 to F100
I don't have issue with access querry BUT need to import the data from it to excel as detailed above.
I will really appreciate for someone to help, got stack and don't know who to get it working.
Cheers,
Mawama
Someone to help with the excel macro to import data from access query to the excel sheet 1.
The access Query has been constrained with date parameter criteria as "Between[Date From] And [Date To]"
Note this date to be taken or referred from excel sheet 1 on cell H3 (date from) and H4 (date to)
A excel macro able to clear out excel sheet 1 on column A1 to F100 and paste the new access query data to the excel column A1 to F100
I don't have issue with access querry BUT need to import the data from it to excel as detailed above.
I will really appreciate for someone to help, got stack and don't know who to get it working.
Cheers,
Mawama
Last edited: