StrataFrame Forum » .NET Forums » General .NET Discussion » export data to dbf format

export data to dbf format

Diu King,Tiong — Mon, 21 Nov 2011 19:12:01 GMT

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

RE: export data to dbf format

Diu King,Tiong — Mon, 21 Nov 2011 19:12:01 GMT

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

RE: export data to dbf format

Trent L. Taylor — Fri, 18 Nov 2011 09:56:02 GMT

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.

RE: export data to dbf format

Alex Luyando — Fri, 18 Nov 2011 09:53:04 GMT

Hi all.

FWIW, I do this in the opposite direction: I have users who perform research and store their findings in DBFs as a sort of staging area. When they are ready to actually persist these records to the official database (SQL server), I fill a StrataFrame business object that's sourced by the DBFs, and copy the data to BOs that are tied to the appropriate SQL server tables and SAVE(). Works very nicely.

RE: export data to dbf format

Diu King,Tiong — Thu, 17 Nov 2011 18:51:15 GMT

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?

RE: export data to dbf format

Trent L. Taylor — Wed, 16 Nov 2011 10:28:51 GMT

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

RE: export data to dbf format

Edhy Rijo — Tue, 15 Nov 2011 22:07:58 GMT

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.