public static void SqlToDbf()
		{
			string aFileName = System.Configuration.ConfigurationSettings.AppSettings.Get("path");

			// connection string
			string con_str = System.Configuration.ConfigurationSettings.AppSettings.Get("con_str");

			// конект на базу
			System.Data.OleDb.OleDbConnection link = new OleDbConnection(con_str);
			
			link.Open();
			
			// виборка
			string sqlcmd = "exec dbo.someSP";

			System.Data.OleDb.OleDbCommand aOleDbCommand = new OleDbCommand(sqlcmd, link);

			//запомним состояние коннекта
			//ConnectionState oldConnectionState = aOleDbCommand.Connection.State;

			try
			{
				aOleDbCommand.CommandTimeout =  600 ;
				OleDbDataReader SchemeDataReader = aOleDbCommand.ExecuteReader();

				DataTable SchemeDataTable = new DataTable();
				SchemeDataTable = SchemeDataReader.GetSchemaTable();

				//формируем CREATE TABLE... и SELECT...
				string CreateCommand = "CREATE TABLE [" + Path.GetFileName(aFileName) + "] (";
				string SelectCommand = "SELECT ";

				for(int i =  0 ; i < SchemeDataReader.FieldCount; i++)
				{
					SelectCommand += SchemeDataTable.Rows[i].ToString();
					CreateCommand += SchemeDataTable.Rows[i].ToString() + " " + GetDbfFieldType(SchemeDataTable.Rows[i]);
					if (i +  1  < SchemeDataReader.FieldCount)
					{
						CreateCommand += ", ";
						SelectCommand += ", ";
					}
				}
				CreateCommand += ")";
				SelectCommand += " FROM [" + Path.GetFileName(aFileName) + "]";

				//закрываем запрос
				SchemeDataReader.Close();

				//создаем коннект для dbf
				string dbfConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path.GetDirectoryName(aFileName) + ";Extended Properties=dBase IV;Persist Security Info=False";
				OleDbConnection dbfConnection = new OleDbConnection(dbfConnectionString);

				//запрос для создания dbf
				OleDbCommand dbfCommand = new OleDbCommand(CreateCommand, dbfConnection);

				//создаем dbf таблицу
				dbfConnection.Open();
				dbfCommand.ExecuteNonQuery();
				dbfConnection.Close();

				//теперь перекачиваем данные

				//dbf запрос
				OleDbCommand dbfSelectCommand = new OleDbCommand(SelectCommand, dbfConnection);

				//дата адаптеры
				OleDbDataAdapter OleDbAdapter = new OleDbDataAdapter(aOleDbCommand);
				OleDbDataAdapter dbfAdapter = new OleDbDataAdapter(dbfSelectCommand);

				//датасет
				DataSet tmpDataSet = new DataSet();

				//заполняем tmpDateSet
				OleDbAdapter.AcceptChangesDuringFill = false;
				OleDbAdapter.Fill(tmpDataSet, "tmpTable");

				//пишем в файл
				OleDbCommandBuilder OleDbBuilder = new OleDbCommandBuilder(dbfAdapter);
				dbfAdapter.Update(tmpDataSet, "tmpTable");

			}
			catch (Exception e) 
			{
				//				throw(e);
				string err = e.Message;
			}
			finally
			{
				link.Close();
			}
		}

				for(int i =  0 ; i < SchemeDataReader.FieldCount; i++)
				{
					SelectCommand += SchemeDataReader.GetName(i);
					CreateCommand += SchemeDataReader.GetName(i) + " " + GetDbfFieldType(SchemeDataTable.Columns[i].DataType.ToString());
					if (i +  1  < SchemeDataReader.FieldCount)
					{
						CreateCommand += ", ";
						SelectCommand += ", ";
					}
				}