Creating dbf file from dataset in VB.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ajit Malkar - 04 Oct 2005 08:01 GMT

I want to create a dbf (foxpro) file from a dataset in VB.Net (Framework 1.1)
in VB.Net program. The dataset has data which needs to be copy to dbf. How to
do this?

Reply to this Message

Cindy Winegarden - 04 Oct 2005 17:45 GMT

Hi Ajit,

You can use standard DDL to create FoxPro tables, and use the FoxPro and
Visual FoxPro OLE DB data provider which is downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates .

'-- Character, Integer, Numeric, Date, DateTime, Memo
strSQL = "Create Table MyTable (Field1 C(10), Field2 I, Field3 N(10, 2),
Field4 D, Field5 T, Field6 M)"

Signature

Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

>I want to create a dbf (foxpro) file from a dataset in VB.Net (Framework
>1.1)
> in VB.Net program. The dataset has data which needs to be copy to dbf. How
> to
> do this?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...