Export Delimited issue

[mattc66 via AccessMonster.com]

Hi All,

I am exporting out of access using a macro and the transer type is Export
Delimited. The data that I am exporint have 3 decimal placed. For some reason
when I export it, it only puts 2 decimals and drops off the 3rd. Does anyone
have a suggestion on what I can do to resolve this issue. I need the 3rd
decimal place.

Matt

 

[Steve Schapel]

Hi Matt,

I am not aware of the reason for this. Are you exporting to a text file?

One thing you could try, to resolve the problem, is to do this for each
affected field in the query that you are exporting from...
AnotherName: Format([YourNumberField],"#.000")

 

[mattc66 via AccessMonster.com]

That solved the issue. I have one more issue, if there is two commas ,, they
need to be seperated by
double quotes ,"",. When I export the data as show below if there is missing
data it is not adding the
double quotes. Does anyone know how I could resolve this issue.


"K","0068777",,"25.000",0.00,"1B","1PRIME"
"K","0068777","6999-96",".050",0.00,"1B","1PRIME"

Hi Matt,

I am not aware of the reason for this. Are you exporting to a text file?

One thing you could try, to resolve the problem, is to do this for each
affected field in the query that you are exporting from...
AnotherName: Format([YourNumberField],"#.000")

Hi All,

[quoted text clipped - 5 lines]

have a suggestion on what I can do to resolve this issue. I need the 3rd
decimal place.

 

[Steve Schapel]

Matt,

In a similar vein to my earlier suggestion, try it like this...

NewField: Nz([YourFieldThatCouldBeNull],"")

 

[mattc66 via AccessMonster.com]

That worked - Thank you

Matt,

In a similar vein to my earlier suggestion, try it like this...

NewField: Nz([YourFieldThatCouldBeNull],"")

That solved the issue. I have one more issue, if there is two commas ,,
they

[quoted text clipped - 6 lines]

"K","0068777",,"25.000",0.00,"1B","1PRIME"
"K","0068777","6999-96",".050",0.00,"1B","1PRIME"

 

[Monika]

3251321