hi all,

im using vb.net with the database sql server 2008. what should i need to do if i try to export data to dbf format from my dataset.

Please advice and thanks

Hi,
What I have done before is create a BO with a VFP connection to the dbf table, then in your application you can add the data to the VFP BO and then save it, of course you will have to know the dbf table structure ahead of time and also have a connection to that table, you will also need the VFPOLE drivers.

Edhy Rijo

Edhy is right, you will definitely need to use some type of OLEDB provider to create the export.  Below is an article showing how to do this.

http://asp.net.bigresource.com/ADO-NET-Export-from-datatable-to-dbf-file-ehEtc3WyX.html

Thanks and appreciate Edhy and Trent for your guys replied.
Btw Trent, i use the OLEDB provider to create the export but when i create the field with numeric(5,2) and the exported dbf giving me the field numeric(20,4).
How can i solving it?

Hi all. 

Tiong,

Man, off the top of my head, I have no idea what is going on here.  I would have to know a lot more about your code and what is going on in your environment, logic, etc.  But I know this, that if you are dealing with DBF tables, and the OLEDB provider, there is always a little "wonkiness."  When we were writing our conversion tools from VFP to SQL, we had a number of situations like this.  And each time we would just setup a small scale test.  We had a Frankenstein test dialog that we lived on while trying to work through VFP related weirdness.  Generally by scaling it down in a test environment where would could make quick changes and try things quickly, we were able to isolate the issue and create a workaround.  This would be my suggestion to you.  Hope this helps a little.

Hi Trent,

http://stackoverflow.com/questions/3551918/numeric-field-width-in-dbf-file-inconsistent-when-created-with-oledb-net
above link is my actual problem.
Some website told there is the oledbconnection limitation


regards