Transfer Spreadsheet includes '

[Matt]

When i use Transfer Spreadsheet to export a query into Excel, every record is
preceded with '. I can't use Output To becase the query has too many
records. Is there any way around this?

 

[Ken Snell [MVP]]

Is the ' character causing any problem? That is done so that EXCEL will
recognize the data as text and not numeric or date. And the ' should not
interfere with the data in EXCEL.

If you want to avoid this, you'll need to use Automation to open an EXCEL
workbook and write your data directly into the worksheet. Slower than
TransferSpreadsheet and you'll need to use VBA code to do it.

 

[Matt]

The ' character only messes up the numeric fields. Users want to filter the
excel data based on a criteria, then use the sum function for a numeric
field, but the result is always 0.

 

[Ken Snell [MVP]]

What are you exporting -- a table or a query? What is the SQL statement of
the query? Apparently, ACCESS thinks your "numeric" field is a text field?