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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RHarwoodCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.