excel macro to execute multiple query & fetch records -

as of have 1 standard database connection (via menu or toolbar) working fine. fetch records 3 different period ( each sheet can have different query). before positing did various attempts couldn't able fetch record via macro. looking suggestion or direction implement requirement.

cell a1 = "name".

for,sheet1: select "name" testdb

for,sheet2: select "name" testdb data >= abc & date <=xyz

for,sheet3: select "name" testdb wehre data >= xyx

use record macro button in developer tab record actions take when create such connection parameters want.

then stop recording , go vba screen, take @ how code looks , either change want liking or record 3 versions way.

now integrate these vba codes vba script.