problme exporting a table as a text file

[russ]

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

[David Seeto via AccessMonster.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.

--
Message posted via http://www.accessmonster.com

[russ]

"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

[russ]

"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

[Bas Cost Budde]

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