Exporting from Access to Excel

[smoker1]

I am creating Macros to export some Access table data into an existing worksheet (for graphing purposes). If my field is 3.9%, it transfers into notepad as .03 and therefore converts in Excel as 3%.

I have tried setting the table decimal point properties to as many as 5, and it still doesn't work.

I have considered using the "Analyze it with MS Excel" option, but don't know how to put that into a macro.

Does anyone know how to work around this??

--Angela

 

[KenG]

Are you exporting first to Notepad? If so, why? Have you tried going straight into Excel, the values will be transferred correctly then. Use TransferSpreadsheet.