TOPIC: Changing SQLite to OleDB Adapter

// modify here the path were your dBASE files located
string dbfiles = @"D:\CLC_Test";

public object DoWork()
{
	// accessing the WRITE Adapter
	OleDBAdapter adapter = (OleDBAdapter)AdapterWrite;

	// optain the table name
	string tablename = adapter.SQL;

	if (File.Exists(Path.Combine(dbfiles, tablename + ".dbf")))
	{
		// if the dBASE table file already exist no further action!
		return null;
	}

	// build the create table statement
	string sql = "create table [" + tablename + "] (";

	int len = 0;
	int count = 0; 
	foreach(Field f in adapter.Fields)
	{
		if (count > 0)
    			sql += ", ";		

		DatabaseAdapterField field = (DatabaseAdapterField)f;

		sql += "[" + field.Name + "] ";
   		switch(field.DataType)
   		{
			case DataType.String:
				len = field.Length;
				if (len == 0)
      				len = 100;

				//SQL Datentyp for strings
				sql += "varchar(" + len.ToString() + ")";
				break;


			case DataType.Date:
			case DataType.Time:
			case DataType.DateTime:
				//SQL Datentyp for datetime
				sql += "datetime";
				break;

			case DataType.Integer:
			case DataType.Boolean:
				//SQL Datentyp for Int (integer)
				sql += "Integer";
				break;

			case DataType.Double:
			case DataType.Decimal:
			case DataType.Currency:
				//SQL Datentyp für Double and Currency perhaps use numeric(18,2) ...
				sql += "Float";
				break;
   		}
   
   		if (field.PrimaryKey)
			sql += "not null ";
   
   		count++;
  	}

  	sql += " );";

	// execute the SQL statement and create the table
	adapter.Execute(sql);

	// result not needed!
	return null;
}