Solved

MS-Access -> dBase III currency export

Posted on 1997-11-16
4
298 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Error in query expression 3 37
Access Excel export not behaving 2 27
How autonumber field on a form 16 19
Acc 2010 pause execution 10 10
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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.

862 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now