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

problme exporting a table as a text file

P: n/a
Hi

I am in the unfortunate position of having to use some code someone
has programmed in access and i have to get the data out. i am picking
a table to export and exporting it as a text file. unfortunately, the
export wizard deosnt display the table in the same order as the table
so it is hard to compare. when it has exported, it has often knocked
digits off floating point numbers. i dont know why.

any ideas?

Thanks

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


P: n/a
The number of digits that floating point numbers are exporting with after the decimal point is controlled by the Regional Settings on teh Control Panel of the PC on which MS Access is installed.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #2

P: n/a
"David Seeto via AccessMonster.com" <fo***@AccessMonster.com> wrote in message news:<fd******************************@AccessMonst er.com>...
The number of digits that floating point numbers are exporting with after the decimal point is controlled by the Regional Settings on teh Control Panel of the PC on which MS Access is installed.


Hi

I wish it was as simple as that...I looked at my regional settings and
it is set to 2 decimal places. this gives the following

in form in text file

12.40756 12.40
0.000003 3.0e-06
1.24075E-07 1.24075e-07
7.456287E-08 7.456287e-08

ie everything ok apart from the 12.40 has been shortened

if i change the regional settings to 5 decimal places then they are
all ok. unfortunately, i have 15000 lines and only a selection are
being shortened and it is not always easy to see which

anyway, thanks for your help, it works now. just micrfosoft being
useless as usual

russ
Nov 13 '05 #3

P: n/a
"David Seeto via AccessMonster.com" <fo***@AccessMonster.com> wrote in message news:<fd******************************@AccessMonst er.com>...
The number of digits that floating point numbers are exporting with after the decimal point is controlled by the Regional Settings on teh Control Panel of the PC on which MS Access is installed.


and do you know why the output text is in a different row order to the
form? what is the logic?

russ
Nov 13 '05 #4

P: n/a
russ wrote:
"David Seeto via AccessMonster.com" <fo***@AccessMonster.com> wrote in message news:<fd******************************@AccessMonst er.com>...
The number of digits that floating point numbers are exporting with after the decimal point is controlled by the Regional Settings on teh Control Panel of the PC on which MS Access is installed.

and do you know why the output text is in a different row order to the
form? what is the logic?


A table is unordered.

I suggest you base both the form and the export on a query. You can
provide a sort order then.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.