VBA for extracting data from Access Data Base.

[Godders199]

Hello, I am after some help, I am unable to find any examples of VBA for the task i need to automate.

I need to be able to import from an existing Access data base, all the rows with a sale date within the last 30 days. ( there is a column heading "sale date")

If anyone has any examples they could provide or a link it would be much appreciated.


Currently i have just linked the excel workbook and Access together and then remove the unwanted rows in excel, but has the database becomes larger this is not an efficient solution.

 

[Joe4]

I am not sure of the current methods you are using to link Access to Excel, but I think the following should work.
Put the criteria in an Access query, so that the data is filtered in Access.
Then link to the Access query instead of the Access table.

 

[Godders199]

thanks, query written and all works