[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

How to create a dbf file so that it can be opened in Excel

sahil

3/27/2008 8:08:00 AM

Can any one please help me out.


I am creating a dbf file for FoxPro

with this connection

m_ConnOLEDB = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.
4.0;Data Source=" + strIniOutPath + ";Extended Properties=dBASE IV");


strCreate = "Create Table " + strDBFName + "(";
strCreate += "Name varchar(100), Data " + "M" +
"(10))";

OleDbCommand cmdCreate = new
OleDbCommand(strCreate, m_ConnOLEDB);

cmdCreate.ExecuteNonQuery();
m_ConnOLEDB.Close();



This successfully create a dbf file . but this file could not be
opened in Excel..

Can you please help me ..
if you have any solution please mail me at: khaleek_ahmad@yahoo.com

Thanks in adanvce.