Search results

I am using Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim xlWS As Excel.Worksheet Dim acRng As Variant Dim xlRow As Integer Dim qry As QueryDef Dim rst As Recordset Set xlApp = New Excel.Application Set xlWB =...

I need to export data from multiple access tables into a single Excel template. The template already exists but has more columns then the access database and the data has to skip some columns. Say columns are A B C D E F G I need to take data from an access table and put that data into A B...