Decimals in dbf export? - Please HELP

[cliv]

I use vb6 to work with an Access2000 mdb.
I need to export e table into dbaseIV and i use:

Database.Execute "SELECT * INTO [dBase IV;DATABASE=" & App.Path & "\].[TEST] FROM [Repartitoare]"

BUT i have one problem.
One field in "Repartitoare" Table have 9 decimals...but export dbf field have only 5.
I don't want to use a structure create with FoxPro and then INSERT...INTO.
HOW CAN I EXPORT DBF WITH 9 DECIMALS.?????

Please Help
Sorry for my english, hope you undestand.

[Hack]

Welcome to DevX :WAVE:

What is the field type that you are dealing with?

[cliv]

Field type are DOUBLE and every value from this field are 9 decimals.

[jggtz]

Are your dbaseIV drivers up to date ?

Try using Visual Fox Pro

[Hack]

dBaseIV is pretty old. jggtz brings up a good point about the drivers.

Are you certain a database of this age is able to handle the numbers that you need to use?