[OT] MS Access export to text

The database is is located on my PC.
I just experimented with a very simple data,
imported the following: "P1.25MMX13/64X3/4-NCB",0.0065
when exported the same data I got the following:
"P1.25MMX13/64X3/4-NCB",6.5e-03
no matter what format I change the field to, I got the same result.

Mike T.


----- Original Message -----
From: "Mario Aguirre" <maguirre@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, August 18, 2004 2:41 PM
Subject: RE: [Vantage] [OT] MS Access export to text


>
> Mike,
>
> I have never seen that in calculated-exported fields. Did you do an export
> specification file to the table/query? The specification file defines the
> way information should be exported. Also, are you working in terminal
> server? Sometimes, my terminal server does goofy things with data...
>
> Mario Aguirre
> Lakin General
>
> -----Original Message-----
> From: miket91326 [mailto:miket@...]
> Sent: Wednesday, August 18, 2004 4:34 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] [OT] MS Access export to text
>
> Hi,
>
> I calculated the weghts on some of our parts in MS Access but when I
> export the table to a text file it converts the weghts into
> scientific notations instead of numbers. Any idea how to get around
> it?
> Thank you in advance!
>
> Mike Tonoyan / All American Products Co.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=129ml6ru5/M=298184.5285298.6392945.3001176/D=gr
>
oups/S=1705007183:HM/EXP=1092951241/A=2319498/R=0/SIG=11thfntfp/*http:/www.n
> etflix.com/Default?mqso=60185352&partid=5285298> click here
>
>
>
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
> :HM/A=2319498/rand=200333129>
>
> _____
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> <http://docs.yahoo.com/info/terms/> Service.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
Hi,

I calculated the weghts on some of our parts in MS Access but when I
export the table to a text file it converts the weghts into
scientific notations instead of numbers. Any idea how to get around
it?
Thank you in advance!

Mike Tonoyan / All American Products Co.
Mike,

I have never seen that in calculated-exported fields. Did you do an export
specification file to the table/query? The specification file defines the
way information should be exported. Also, are you working in terminal
server? Sometimes, my terminal server does goofy things with data...

Mario Aguirre
Lakin General

-----Original Message-----
From: miket91326 [mailto:miket@...]
Sent: Wednesday, August 18, 2004 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] MS Access export to text

Hi,

I calculated the weghts on some of our parts in MS Access but when I
export the table to a text file it converts the weghts into
scientific notations instead of numbers. Any idea how to get around
it?
Thank you in advance!

Mike Tonoyan / All American Products Co.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129ml6ru5/M=298184.5285298.6392945.3001176/D=gr
oups/S=1705007183:HM/EXP=1092951241/A=2319498/R=0/SIG=11thfntfp/*http:/www.n
etflix.com/Default?mqso=60185352&partid=5285298> click here


<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
:HM/A=2319498/rand=200333129>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]
If you did the calculation in a query, did you set the format for the
field before exporting? If it is in a table, you can set the format in
the table design. A workaround might be to copy the data to the
clipboard and paste it into Word or Excel and then save it.

Butch

________________________________

From: miket91326 [mailto:miket@...]
Sent: Wednesday, August 18, 2004 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] MS Access export to text


Hi,

I calculated the weghts on some of our parts in MS Access but when I
export the table to a text file it converts the weghts into
scientific notations instead of numbers. Any idea how to get around
it?
Thank you in advance!

Mike Tonoyan / All American Products Co.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129ml6ru5/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1092951241/A=2319498/R=0/SIG=11thfntfp/*htt
p://www.netflix.com/Default?mqso=60185352&partid=5285298>

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2319498/rand=200333129>

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
If you use Microsoft query directly through Excel, you can place your
calculation in adjacent cells.
Then set the query properties to refresh each time the file is open and
you'll have the most current record set in the format you want each time
you open any given report.
The formulas can be set to adjust automatically to the number of cells any
given record set fills.
It's saved me a lot of time and effort supporting my users.

--------------------------------------------------------------------
Jim Kennedy
Manager, Information Systems
ST Inverter America
Cell: (832) 922-1364
Phone: (281) 506-3144
Fax: (281) 506-3101




"Butch Menge" <bmenge@...>
08/18/2004 04:57 PM
Please respond to vantage


To: <vantage@yahoogroups.com>
cc:
Subject: RE: [Vantage] [OT] MS Access export to text


If you did the calculation in a query, did you set the format for the
field before exporting? If it is in a table, you can set the format in
the table design. A workaround might be to copy the data to the
clipboard and paste it into Word or Excel and then save it.

Butch

________________________________

From: miket91326 [mailto:miket@...]
Sent: Wednesday, August 18, 2004 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] MS Access export to text


Hi,

I calculated the weghts on some of our parts in MS Access but when I
export the table to a text file it converts the weghts into
scientific notations instead of numbers. Any idea how to get around
it?
Thank you in advance!

Mike Tonoyan / All American Products Co.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129ml6ru5/M=298184.5285298.6392945.3001176/
D=groups/S=1705007183:HM/EXP=1092951241/A=2319498/R=0/SIG=11thfntfp/*htt
p://www.netflix.com/Default?mqso=60185352&partid=5285298>

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group
s/S=:HM/A=2319498/rand=200333129>

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links


Yahoo! Groups Sponsor

ADVERTISEMENT




Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]