?
Solved

MS-Access -> dBase III currency export

Posted on 1997-11-16
4
Medium Priority
?
310 Views
Last Modified: 2006-11-17
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.
0
Comment
Question by:RRaszka
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
RHarwood earned 200 total points
ID: 1959830
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
 

Author Comment

by:RRaszka
ID: 1959831
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
 
LVL 1

Expert Comment

by:RHarwood
ID: 1959832
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
 

Author Comment

by:RRaszka
ID: 1959833
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question