Export from Access to Excel - convert to number

  • Thread starter Thread starter Martina
  • Start date Start date
M

Martina

Hi

when I download or copy numbers from Access to Excel a new
feature "convert to number" appears.
I am forced to mark all numbers and click "convert to
numbers" otherwise Excel doesn't calculate.
Is there anyway to download from Access to Excel without
having to convert the text to numbers first (like it used
to be before)?
I have huge data exports and this takes up lots of time.

Thank you, Martina
 
What version are you using? From 2000 the "Office LInks"
option "analyze with Excel" avoids this problem (though
this could well be what you are doing in a later version,
if so, sorry for the unhelpful reply.
 
In Access, you can use TransferSpreadsheet in code, e.g.:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"qryProductionData", strPathFile

or in a macro.
 
If you leave them as text, you can later convert all to numbers by copying an empty cell, then
select the column of "text numbers" and Edit/Paste Special and select the Add and Values
options.
 
Back
Top