Hi
What I am trying to do is to export into excel a query results.
So far everything works fine, but when I open the excel file then I discover that the file contains the famous error: Number stored as Text
How can I make it so that the exported excel file will have the data formated cells as General for ex?
open to any ideas
Here is the code I use so far:Private Sub SEND_file_Click()
Dim Filename As String
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "STRIPES_EXPORT", "\\filepath\STRIPES_PR.xlsx", True
MsgBox " STRIPES -TABLE CREATED " & vbCrLf _
& "FILE SAVED" & vbCrLf, vbYes + vbInformation, "SUCCESSFULLY CREATED"
End Sub