Hi Everyone,
I have a table in Access where my users upload the information they'd like to connect to relational data in a knowledge database in order to reduce the scope of their search to what matches the ids they're looking for.
I have them click a button and I'd like them to find and append their excel spreadsheet template data to a table in access
I then want to requery the query the table is attached to
I then want to export the query results to excel
Finally to clear the contents of the table in access
The only problem is my acexport transferspread isn't working.
I've used this model for many other similar exports already and I think it's working fine, at least they're not getting error messages.
Here's the code if anyone has any recommendations:
Private Sub CommandCumulativeBench_Click()
Call Upload_PPNBench
DoCmd.Requery (qry3a_Select_PPNBench)
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry3a_Select_PPNBench", strExcelFile, True
DoCmd.Requery (qry3b_Select_PPNBench_dlt)
End Sub
Thanks in advance