sormv
asked on
DBF to CSV conversion using C#
Hi,
I am converting a dbf file into csv file using C#. My program is working fine for file having fewer columns in dbf file. If the dbf file has more than 255 columns, I am getting the error "FILENAME" is not a table.
I am using Visual foxpro OLEDB friver. I downloaded drivers from
http://www.microsoft.com/downloads/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en
I tried with Microsoft dBase ODBC and OLE DB drivers. Both are giving the errors.
With OLEDB:
----------------
The Microsoft Jet database engine could not find the object 'Temp.dbf'. Make sure the object exists and that you spell its name and the path name correctly
With DBASE
------------------
ERROR [42S02] [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object "Temp.dbf'. Make sure the object exists and that you spell its name and the path name correctly
File Temp.dbf is existing.
Initially, I tried with these drivers. But I was getting this errors and then tried with visual foxpro drivers. It is working with other files except one file which has 261 columns.
Connection strings are :
-------------------------- --
string inputDir = @"C:\Temp_DBF" //my dbf file location
string fileName = "Temp.dbf"; // Tried with Temp also.
string dataSource = inputDir + "\\" + fileName;
string strConn = @"Provider=Microsoft.Jet.O LEDB.4.0;D ata Source=" + inputDir + ";Extended Properties=dBASE IV";
//string strConn = @"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq= " + inputDir + ";";
//string strConn = @"Provider=VFPOLEDB.1;Data Source=" + dataSource + ";Persist Security Info=False;";
I tried with dBase 5.0 also, I am getting the error "Could Not Find Installable ISAM"
You can find more information here...
https://www.experts-exchange.com/questions/22744623/DBF-to-CSV-conversion-using-C.html
Any Help.
Thanks In Advance!!!
I am converting a dbf file into csv file using C#. My program is working fine for file having fewer columns in dbf file. If the dbf file has more than 255 columns, I am getting the error "FILENAME" is not a table.
I am using Visual foxpro OLEDB friver. I downloaded drivers from
http://www.microsoft.com/downloads/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en
I tried with Microsoft dBase ODBC and OLE DB drivers. Both are giving the errors.
With OLEDB:
----------------
The Microsoft Jet database engine could not find the object 'Temp.dbf'. Make sure the object exists and that you spell its name and the path name correctly
With DBASE
------------------
ERROR [42S02] [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object "Temp.dbf'. Make sure the object exists and that you spell its name and the path name correctly
File Temp.dbf is existing.
Initially, I tried with these drivers. But I was getting this errors and then tried with visual foxpro drivers. It is working with other files except one file which has 261 columns.
Connection strings are :
--------------------------
string inputDir = @"C:\Temp_DBF" //my dbf file location
string fileName = "Temp.dbf"; // Tried with Temp also.
string dataSource = inputDir + "\\" + fileName;
string strConn = @"Provider=Microsoft.Jet.O
//string strConn = @"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=
//string strConn = @"Provider=VFPOLEDB.1;Data
I tried with dBase 5.0 also, I am getting the error "Could Not Find Installable ISAM"
You can find more information here...
https://www.experts-exchange.com/questions/22744623/DBF-to-CSV-conversion-using-C.html
Any Help.
Thanks In Advance!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Any Idea.. how to read clipper dbf files using clipper odbc drivers..
Thanks...
Thanks...
http://www.vistasoftware.com/default.asp
Try the link above. They have a 30day free trial.
Try the link above. They have a 30day free trial.
ASKER
I am gettiing the error. what is the solution for this. How to read dbf file with more than 255 columns.
Thanks..