I have a weird issue going on. I have an Access 2007 database and an XLS with multiple tabs. As of now, i use the acspreadsheettypeexcel9 command to export data from Access to the XLS putting specific tables of data into specific tabs. This works perfectly. However i would like to do the same thing but going to an XLSX. So i tried using acspreadsheettypeexcel12 and acspreadsheettypeexcel12Xm
l but when i run it no data gets transferred to the XLSX. Can anyone think of a reason why this might not work?
Below is a sample of one of my export lines. the sFn variable prompts the user to choose the XLSX.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "FC_Count of File Creations by Day", sFn, True, "2A_FileCreationbyDay!A1:B1"