Help with TransferDatabase to dbf

[Arvin Villodres]

I'm trying to export a table into dbf form and I'm doing
this with the use of TransferDatabase function.

How do I export a table by agreeing with some conditions.

a. FieldAmount must be nine (9) numbers or characters
with two(2) decimals. I used Double, Standard, and 2
decimal point in the Table design but whenever I try to
open the exported file 20 numbers appear and five decimals
instead of two appears.

I hope you could help me with this one. Thank you very
much you all and God bless.

 

[Immanuel Sibero]

Hi Arvin

I had to deal with this issue in the past and couldnt find a way to control
the structure of the dbf file. I ended up creating the dbf file with the
desired structure and linked it to Access. I then used Append query (and
Delete query if necessary) to load the dbf file. Maybe others can chime in
with a better approach.

HTH,
Immanuel Sibero