Access database exported to text file

[=?iso-8859-1?Q?Jean-Fran=E7ois_Legault?=]

Hi,

I'm trying to convert an access database into a text file.
I don't want any symbole( $ or () ) so I have a problem
with the currency format. I tried to change the format
into a number but It's a big database (350 000 entries)
and I have an error message "There isn't enough disk space
or memory".

I need help to resolve this problem !!

Thanks

JF

 

[Joseph Meehan]

Hi,

I'm trying to convert an access database into a text file.
I don't want any symbole( $ or () ) so I have a problem
with the currency format. I tried to change the format
into a number but It's a big database (350 000 entries)
and I have an error message "There isn't enough disk space
or memory".

I need help to resolve this problem !!

Thanks

JF

I would guess you could create a query and format the Currency field to
show the way you want. You don't need to change the field type.

Hope that helps.

 

[John Vinson]

Hi,

I'm trying to convert an access database into a text file.
I don't want any symbole( $ or () ) so I have a problem
with the currency format. I tried to change the format
into a number but It's a big database (350 000 entries)
and I have an error message "There isn't enough disk space
or memory".

Export ignores the Format property of fields anyway so don't bother!

Instead, create a Query using the Format() function to cast the
currency fields as a String. That is, if the table contains a field
[Money] shown as $2,128.56 and you want to export it as 2128.56, use a
Query with a field

ExpMoney: Format([Money], "0.00")

Use File... Export to export from this Query rather than directly from
the Table.