how to retrieve data from access between two date ranges using excel vba code

**narsing18** · 07-04-2017, 06:59 AM

Hi Team,

i have created user form to enter data into excel data base that is connected to ms access, now i am trying to retrieve data from access data base , i have created group box with from date and to date with button to press, but i am not sure how to write the code which select the from-date and to-date and retrieve the data between that date range.
i have used date picker to select date.
i am using office 2016

**ranman256** · 07-10-2017, 08:24 AM

SSql = "Select * from table where [date] between #" & range("A1").value & "# and #" & range("B1").value & "#"

i cannot edit add the connection code. The site is blocking it!!

**narsing18** · 07-11-2017, 05:43 AM

Hi , can you please attach your own code.

Regards,
Narsing Rao

how to retrieve data from access between two date ranges using excel vba code

LinkBack

Thread Tools

Rate This Thread

Display

how to retrieve data from access between two date ranges using excel vba code

Re: how to retrieve data from access between two date ranges using excel vba code

Re: how to retrieve data from access between two date ranges using excel vba code

Thread Information

Users Browsing this Thread

Similar Threads

Data Restriction Retrieve from Excel/Access

Retrieve access data into excel

Retrieve data from Access

[SOLVED] How to retrieve the value within the table from Access into Excel?

How to get Excel to retrieve aggregate data from Access

VBA coding to retrieve data from Access to Excel :S

[SOLVED] Retrieve MS Access DDB Property in Excel VBA

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions