Access Database Import Data From Specific Date Range

Hi Team,

I have an Excel sheet that I use to important data from an access database but I would like to control the data that it imports.. Basically, the database contains a column that contains the date that entry has been enterred in the database. When I import my data onto excel, I would like it to import the data from a given date range the user would setup. I would imagine that this would have to be through VBA so let's say I have a UserForm that contains 2 DTPickers where a user would input the date range.

I have little experience with SQL queries, can you help me with this type of query?

I tried the code below but it gives me a compile error : User-defined type not defined on line "Dim dbConnection As ADODB.Connection"


Thanks

Please Login or Register  to view this content.

Hi JapanDave,

I tried that and now the code starts running but i get an object required error on line "Sheet1.Range("A2").CopyFromRecordset nsltrackerreport"

Also, can you help with the SQL query respecting the date range selection?

Thanks

Hi, I'm now getting a user-defined type not defined error on line "Dim FSO As New FileSystemObject"

Yeah that worked It was able to import all the table. So now all that's left is for it to import data submitted in the date range selected by user in Userform.

The name of the column in access is called SubmitDate

Thank for your help

Hi Thank again..I reviewed that method and although it's practical, it wouldn't suite the needs in the environment I'm working in where the user will not have direct access to the database table via Access.


I actually tried the SQL Statement below and it worked to get all entries stamped with the date in DTPickerCtrl1

Please Login or Register  to view this content.

Then I tried to accomplish what I initially wanted (Date Range) with the below code :

Please Login or Register  to view this content.

but this is not pulling anything.

Any help on this?

Alright so that somewhat works The reason why i say somewhat its that for example I have 3 entries in the Access Database...One for the 8th, another for the 9th and another for the 10th of December 2015..

When selecting the date range from the 1st of December to the 11th of December, nothing appears....When I select the 1st to the 13th, all 3 appear...It's being weird...any idea why?


PS: I will include the code for how the values are actually processed to the database from another application.

Please Login or Register  to view this content.

And here's the code for when I import the data to excel based on selected date range with your latest mods:

Please Login or Register  to view this content.

I actually got it to work :

Please Login or Register  to view this content.