Solved

MS-Access -> dBase III currency export

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

687 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