Excel macro to import data from access query

[mawama]

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

 

[juddaaaa]

Give this s try

Sub ImportFromAccess()

    Dim objADO As Object
    Dim objRec As Object
    
    Set objADO = CreateObject("ADODB.Connection")
    
    With objADO
        .Provider = "Microsoft.ACE.OLEDB.12.0"
        .Properties("Data Source") = "C:\YourDatabase.mdb"
        .Open
    End With
    
    Set objRec = objADO.Execute("SELECT * FROM your_table_name")
    
    With Sheets("Sheet1").Range("A1")
        .Resize(100, 6).ClearContents
        .CopyFromRecordset objRec, 100
    End With
    
    objADO.Close

End Sub

 

[mawama]

Hello Juddaaaa,

Thanks for the feedback, I have put the macro but yet get stack with the message that "no value given for one or more required parameters" I believe this is associated with the Between (dateFROM) And (dateTO) in my access query.

In my excel these parameters are located in J2 for DateFrom and J3 for DateTo

Please check and advise mate.

Regards,
Mawama

 

[mawama]

As my access query has date range parameters and these are what missing in this code, please check and advise mate.