Export price field in txt file without $ currency symbol

[hg]

We recently upgraded from Access 2000 to 2003. Now when we try to export to
a fixed width txt file the price field always has a $ currency symbol. I
changed the format of the field in the table properties but that doesn't help.

How do I export a price field without the $ currency symbol.

Thanks.

 

[Gina Whipp]

hg,

Exactly what did you change the format to. I don't understand what a fixed
width text field is because I don't have that option to set Fixed width on a
text field. When I do change the field to text it goes out without a
currency symbol. Of course, if you set up Export specs you want to make
sure it's changed in the specification file.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[hg]

Tried changing field type to text and number format to both General number
and fixed; same results. When you export to a Text file the export Text
wizard gives you an option for Fixed Width, you can then go into Advanced to
select a spec template, which we do, but we get the additional $ symbol.

 

[Gina Whipp]

General Number? Are you exporting from Excel? If yes, you might want to
check with the Ecel forum, it's a little further down in the Microsoft
interface. You're in Microsoft Access newsgroup now.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Taylor Randall]

We recently upgraded from Access 2000 to 2003. Now when we try to export
to
a fixed width txt file the price field always has a $ currency symbol. I
changed the format of the field in the table properties but that doesn't
help.
Cool.
How do I export a price field without the $ currency symbol.
I don't know, I'm just a kid.
Thanks.

 

[hg]

When you view the table properties of an Access table you can set the field
type to text, number and many other options. I have tried text and all
plausible number formats and they all result in a $ currency symbol on
export. As a test I even set the number currency symbol to euro; which I
could see in the Access table and query view but changed to a $ currency
symbol upon export to a fixed length file.

HG

 

[hg]

When you view the table properties in Access you can change the field type to
many different things, including general number. I tried changing the price
field to text and all plausible number types but still received to the $
currency symbol on export. As a test I even set the currency symbol in the
table to euro; which showed up in the Access Table and subsequent query but
upon export reverted to the $ currency symbol in the fixed width file.

 

[Gina Whipp]

HG,

Okay, let's be clear because I am testing this...

You export your data FROM Excel TO Access and the exported file still shows
as Currency? So you look at the Excel file and confirm this? Or are you
doing it the opposite?

In Access there is no General Number selection, just Number and then you
select the format from below: Long Integer, Double, Single, etc... but
nothing that says General and that is where I am getting confused.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[hg]

We export from Excel using a tab delimited format. (one the other fields
prevents direct excel import).
We import the file into access. The field in question defaults to
Number/Double. (The tab where you adjust the field type is called General).
It's a price so it looks like 00.00.
We link to ODBC data and prepare the file for export to text and Fixed
width. Once exported the $ currency symbol is the flat file, it does not
appear in Access.

Thanks,
HG

 

[Gina Whipp]

HG,

Okie dokie, my test was off... That being said... when I want to export a
field that I don't want to be a Currency (or a number) I simply put heading
in the first row and do not tell Access that those are headings and it
brings it in as text. Access reads the first few rows so by assigning
headings it will read it as text.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm