AQuery drives data from table1 with 3 fields field 1 is autonumber, field 2 is field name and third field has percentages so a data type is %
When I am using the code below it's transferring the % as ID. so I get field 2 instead of field 3
How can I solve thisCode:Dim Book3 As String Book3 = "C:\Users\Desktop\1\book3.xlsx" DoCmd.TransferSpreadsheet acExport, , "AQuery", Book3