<div>
Great guess Steve -- it worked!<br />
<br />
Thanks,<br />
Ed
</div>


Great guess Steve -- it worked!

Thanks,
Ed

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am exporting data from an Access 2002 query into an EXISTING excel worksheet. &nbsp;The query's data type for the AMOUNT field is CURRENCY, however, everytime it exports the field becomes DATE within excel. &nbsp;I've changed the column's type within the worksheet to CURRENCY, but it keeps converting back to date after an export.<br />
<br />
How can I get the column within the worksheet to remain as CURRENCY?<br />
<br />
Thanks,<br />
Ed
</div>
</div>


Hi,

I am exporting data from an Access 2002 query into an EXISTING excel worksheet.  The query's data type for the AMOUNT field is CURRENCY, however, everytime it exports the field becomes DATE within excel.  I've changed the column's type within the worksheet to CURRENCY, but it keeps converting back to date after an export.

How can I get the column within the worksheet to remain as CURRENCY?

Thanks,
Ed

Access to Excel Type Conversion Question

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.