Creating a DBF File, as part of a shape file, without a DBT file - in C#

Question

I want to create a DBF file: it should be dBase III format.

As part of an ESRI Shapefile
dBase format III
WITHOUT A MEMO \ DBT FILE.
Single column multiple rows.

I've tried a lot of options the closest I got was using this: ( But it creates the annoying memo file along with it ).

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\temp;Extended Properties=dBase III";

using (OleDbConnection connection = new OleDbConnection(connectionString))
using (OleDbCommand command = connection.CreateCommand())
{
    connection.Open();

    command.CommandText = "CREATE TABLE Test (Id Integer, Changed Double, Name Text)";
    command.ExecuteNonQuery();
}

as was suggested here.

what's your question exactly? – CharlesB Dec 12 '11 at 09:36 — CharlesB, Dec 12 '11 at 09:36

score 0 · Answer 1 · answered Dec 26 '11 at 01:23

You probably won't come back to see this but this is to you and others who might benefit:

I'm also working on ESRI's shapefile and found that changing that connection string to specify the Provider to VFPOLEDB solves the problem. Try:

 string connectionString = @"Provider=VFPOLEDB;Data Source=D:\temp;Extended Properties=dBase III";

VFPOLEDB is Visual Fox Pro provider for Ole DB.

Creating a DBF File, as part of a shape file, without a DBT file - in C#

1 Answers1