export to excel - formated

[webisti]

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

[JoeM]

Is the field causing problems in your "STRIPES_EXPORT" table/query a direct field or a calculation?
If it is a calculation, what is the calculation?
If it is a straight field, what is the datatype of that field in Access?
Are you exporting any blanks or nulls in this field?

[webisti]

Great input
base on your analysis I just changed the structure of the linked table so that
I have the results appended in that table as numbers.
then the excel export worked properly and with no errors.

thanks

Webisti