Access database exported to text file

  • Thread starter Thread starter =?iso-8859-1?Q?Jean-Fran=E7ois_Legault?=
  • Start date Start date
?

=?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
 
Jean-François Legault said:
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
Click to expand...

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.
 
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".
Click to expand...

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.
 
Back
Top