.dbf Creation

[Mark Sanders]

Is it possible to create a new dBASE IV .dbf (one that does not already exist) using C#? Mark Sanders sanderssolutions.com

[Mark Sanders]

For those who are interested...

string columnString = "NAME varchar(50), NUMBER int";
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + directory + ";Extended Properties=dBase IV";
string sqlString = "CREATE TABLE " + tableName + " (" + columnString + ")";

OleDbConnection connection = new OleDbConnection(connectionString);
OleDbCommand command = new OleDbCommand(sqlString, connection);
			
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();

Mark Sanders sanderssolutions.com