By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,053 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,053 IT Pros & Developers. It's quick & easy.

export to DBF without decimals?

P: n/a
This is driving me nuts - I'm trying to export my access table to dbaseIII
format. Most of the fields are text except for 2 of them which are
numbers. No matter what I try, the resulting exported file adds a decimal
and four "0" after the numbers. All the numbers in the table have no
decimal showing, nor should they. But 607 gets exported as 607.0000

I've tried everything I can think of - someone please tell me how to get
around this?

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Thu, 10 Mar 2005 18:12:29 -0600, ej@frostNOSPAM.co.edu (Eddie J)
wrote:

Why would you? The value of 607 is equal to the value of 607.0000.
It's just a matter of formatting, which has to do with presentation,
NOT with the actual value.

-Tom.
This is driving me nuts - I'm trying to export my access table to dbaseIII
format. Most of the fields are text except for 2 of them which are
numbers. No matter what I try, the resulting exported file adds a decimal
and four "0" after the numbers. All the numbers in the table have no
decimal showing, nor should they. But 607 gets exported as 607.0000

I've tried everything I can think of - someone please tell me how to get
around this?

Thanks


Nov 13 '05 #2

P: n/a
DFS
Eddie J wrote:
This is driving me nuts - I'm trying to export my access table to
dbaseIII format. Most of the fields are text except for 2 of them
which are numbers. No matter what I try, the resulting exported file
adds a decimal and four "0" after the numbers. All the numbers in
the table have no decimal showing, nor should they. But 607 gets
exported as 607.0000

I've tried everything I can think of - someone please tell me how to
get around this?
Try exporting a query that formats the columns with no decimals.

Thanks

Nov 13 '05 #3

P: n/a
no****@DFS.com (DFS) wrote in <1A******************@fe07.lga>:
Eddie J wrote:
This is driving me nuts - I'm trying to export my access table to
dbaseIII format. Most of the fields are text except for 2 of them
which are numbers. No matter what I try, the resulting exported file
adds a decimal and four "0" after the numbers. All the numbers in
the table have no decimal showing, nor should they. But 607 gets
exported as 607.0000

I've tried everything I can think of - someone please tell me how to
get around this?


Try exporting a query that formats the columns with no decimals.


Can you give me some thought on how that is done?

Thanks much.

Nov 13 '05 #4

P: n/a
Sorry, disregard. Figured out with Format() function. Thanks again.
Try exporting a query that formats the columns with no decimals.


Can you give me some thought on how that is done?

Thanks much.


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.