I have VBA code in an Access DB that exports data as a CSV file. This code works great but I would like to export these as Excel files. When I use the docmd.sendobject..... the database crashes which is how I started using the .csv option. Can I tweak this code to export these as .xlsx? I run through a loop and pass several tables to the docmd.transfertext....
Do While intCtr < 4
strCSVFile = strSavePath & strTable(intCtr) & ".csv"
DoCmd.TransferText transfertype:=acExportDelim, _
intCtr = intCtr + 1