VBA - Importing from Access to Excel

[Rerun]

Thanks in advance for any help offered. My project is as follows:

I have a number of columns that I want to have filled in when a user enters a date, a start time, and an end time. What this information is doing is pulling data from Access based on the date it was entered and then the time it was entered, between the start and end time selected. The columns that the data is entered into is not in the same order as those in the Access file.

So far, here is what I have:

Please Login or Register  to view this content.

What this does is place some of the data into the incorrect columns, does not account for the Date/Time desire, and has some data missing completely.

The starting cell is B10 and ends at a point determined by the amount of data being pulled.

Any help that can be offered would be great!

[rylo]

Hi

Not really sure exactly what you are asking for help to do.

If you want the output to start in B10, then change the line

Please Login or Register  to view this content.

to be

Please Login or Register  to view this content.

or specifically nominate B10 as the output cell.

If you want to restrict the selection criteria then you will have to add the qualifying items to the selection string. Where are the details entered on Import that you want to use to modify the query?

rylo