SQL statements vs Excel RRS feed

  • Question

  • Hi all,

    Just a question.

    Is it possible to use SQL statements in MS Access VBA to retrieve data in an MS Excel workbook?

    I have a databse that uses automation to create an Excel workbook with 12 sheets, one for each month of the year. The columns are created as follows:

    Column A = date of the month (01-01-2018, 02-01-2018 and so on.

    Column B = the WeekDayName of each date, next to the date

    I now retrieve data from a table which contains the dates. I want to select the row where the same date appears and add some data in columns C to O. I thought it might be possible to use a "SELECT" query to retrieve the position in the Excel sheet where the dates correspond.

    If this is possible, I would appreciate some clarity how to achieve this. If not, what would be the easiest way of accomp-lishing this?



    Thursday, February 1, 2018 2:20 PM


All replies