L
Lupe
Hi,
I am using macros with Transferspreadsheet to export 3 queries to an Excel
workbook, each in its own sheet. I have one column with info that have
numbers as well as text. Depending on which criteria I use I can extract only
the records with the numbers and want to use these to do a simple
calculation. However, when the information is exported to Excel every text
column comes with a single quotation mark identifying it as text. When I use
the same query with OutputTo I get it without the quotation mark, but then I
cannot download each query in their own worksheet.
Any help is appreciated. Thanks, Lupe
I am using macros with Transferspreadsheet to export 3 queries to an Excel
workbook, each in its own sheet. I have one column with info that have
numbers as well as text. Depending on which criteria I use I can extract only
the records with the numbers and want to use these to do a simple
calculation. However, when the information is exported to Excel every text
column comes with a single quotation mark identifying it as text. When I use
the same query with OutputTo I get it without the quotation mark, but then I
cannot download each query in their own worksheet.
Any help is appreciated. Thanks, Lupe