MS-Access -> dBase III currency export

When using the save as/export function of access a field defined as currency is exported as 15 character with 5 decimal positions, even after defining the display decimals as 2 positions. Can this be changed? How? When the same function is performed with Excel as the target the resulting spreadsheet does in fact display 2 decimal positions.
RRaszkaAsked:
Who is Participating?
 
RHarwoodConnect With a Mentor Commented:
Base your output for export on a query.  Instead of putting the field in the output row put in this expression (Format([currencyfield],"0.00")  this will force access to give you the output you desire.
0
 
RRaszkaAuthor Commented:
The propsed solution will in fact create a character field int the result dBase database with a length of 254. Since the result table is being input into a third party software package the field in question must be declared as numeric 9 with 2 decimal positions, so the proposed solution does not work.
0
 
RHarwoodCommented:
There is no function in Access to make the output exactly as you want (at least I don't know of one) you may have to try using the CSng(format([currencyfield],"0.00")) to try and cast the output as a single type.  I still don't think this will do it exactly to the DBase format you want.  You may have to export it as text or some other type and then rebuild it in DBase or whatever you are using the DBase file for.
0
 
RRaszkaAuthor Commented:
Thanks for the info. I guess the multiple conversion route is the only answer at this point. It is strange however that using the same save as/export function from Excel will create a dBase databse with a field definition equal to the "DISPLAYED" format not the internal numeric format, and Access will not.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.