DataTable table = new DataTable();

string sql = "select * into [dbo].[MAP_OESK_1] from " + table.TableName; как-то так, это не работает
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();

   using (SqlConnection destinationConnection = new SqlConnection(csDestination))
            {
                destinationConnection.Open();
                using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection))
                {
                    bulkCopy.DestinationTableName = table.TableName; или как-то так, здесь тоже не работает
                    bulkCopy.WriteToServer(table);

select * into TABLE from DATATABLE

select * into

 dataGridView1.DataSource = dt1;
            table = dt1.Copy();
            table.TableName = "dbo.dbfTable";

 public partial class Form1 : Form
    {
        IDataReader sqlReader;
        DataTable table;
        Exception exce = new Exception();
        DateTime DayT = new DateTime();
        string sDirPath;
        string OFDfilename;

        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //string FilePath = "C:\\Work\\TestDBF\\"; //здесь файлы для работы
            string FilePath = sDirPath;
            DayT = DateTime.Now;

            OleDbConnection oledbconnection = new OleDbConnection();
            oledbconnection.ConnectionString = @"Provider=VFPOLEDB.1;Data Source=" + FilePath + "";
            oledbconnection.Open();
            Console.WriteLine(oledbconnection.ConnectionString.ToString()); //сомнения в коректности кода
            OleDbCommand oCmd = oledbconnection.CreateCommand();
            oCmd.CommandText = "SELECT * FROM " + OFDfilename;

            DataTable dt1 = new DataTable();
            sqlReader = oCmd.ExecuteReader(); //?
            dt1.Load(sqlReader);
            //dt1.Load(oCmd.ExecuteReader());
            //oledbconnection.Close();

            progressBar1.Maximum = dt1.Columns.Count;
            dataGridView1.DataSource = dt1;
            dataGridView1.Visible = true;
            table = dt1.Copy();
            table.TableName = "dbo.dbfTable" +DayT.Day+DayT.Hour+DayT.Minute;
            Console.WriteLine(table.TableName);
            textBox4.Text = exce.Message;
            textBox4.Visible = true;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog1 = new OpenFileDialog();
            openFileDialog1.Title = "Select a *.dbf File";
            if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                OFDfilename = openFileDialog1.FileName;
                //sDirPath = openFileDialog1.InitialDirectory;
                sDirPath = Path.GetDirectoryName(OFDfilename);
                Console.WriteLine(OFDfilename);
                Console.WriteLine(sDirPath);
                comboBox1.Text = OFDfilename;
                comboBox1.Items.Add(OFDfilename);
                //int count = comboBox1.Items.Count;
                //if (count == 6) comboBox1.Items.RemoveAt(0);
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            string sTableName="dbo.dbfTable" + DayT.Day + DayT.Hour + DayT.Minute;
            string csDestination = "Data Source=VLR1-STEN01;User ID=******;Password=********;" +
            "Initial Catalog=Test;MultipleActiveResultSets=true";
            SqlConnection sqlcon = new SqlConnection();
            sqlcon.ConnectionString = csDestination;
            sqlcon.Open();
            // checking whether the table selected from the dataset exists in the database or not
            string exists = null;
            try
            {
                string sqlSelect = "SELECT * FROM sysobjects where name = '" + table.TableName + "'";
                Console.WriteLine(sqlSelect);
                SqlCommand cmd = new SqlCommand(sqlSelect, sqlcon);
                textBox4.Text = exce.Message;
                textBox4.Visible = true;
                exists = cmd.ExecuteScalar().ToString();
            }
            catch (Exception exce)
            {
                exists = null;
            }

            // if does not exist
            if (exists == null)
            {
                // selecting each column of the datatable to create a table in the database
                foreach (DataColumn dc in table.Columns)
                {
                    progressBar1.PerformStep();
                    if (exists == null)
                    {
                        string sqlCreate = "CREATE TABLE " + table.TableName + "(" + dc.ColumnName + " varchar(MAX))";
                        Console.WriteLine(sqlCreate);

                    SqlCommand createtable = new SqlCommand(sqlCreate, sqlcon);
                    createtable.ExecuteNonQuery();
                    exists = table.TableName;
                    }
                    else
                    {
                        string sqlAlter = "ALTER TABLE " + table.TableName + " ADD " + dc.ColumnName + " varchar(MAX)";
                        Console.WriteLine(sqlAlter);
                    SqlCommand addcolumn = new SqlCommand(sqlAlter, sqlcon);
                    addcolumn.ExecuteNonQuery();
                    }
                }
                // copying the data from datatable to database table
                using (SqlBulkCopy bulkcopy = new SqlBulkCopy(sqlcon))
                {
                    try
                    {
                        bulkcopy.DestinationTableName = table.TableName;
                        bulkcopy.WriteToServer(sqlReader); //Недопустимая попытка вызвать FieldCount при закрытом устройстве чтения.  или Недопустимая попытка вызвать GetSchemaTable при закрытом устройстве чтения.//?????
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                }
            }
            // if table exists, just copy the data to the destination table in the database
            else
            {
                using (SqlBulkCopy bulkcopy = new SqlBulkCopy(sqlcon))
                {
                    try
                    {
                        bulkcopy.DestinationTableName = table.TableName;
                        bulkcopy.WriteToServer(sqlReader);
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                }
            }
            sqlcon.Close();
            Console.WriteLine("Successfully to update the table.");
            textBox3.Text = "Сворачивай манатки, все...";
            textBox3.Visible = true;
            textBox4.Text = exce.Message;
            textBox4.Visible = true;
        }

 sqlbulkcopy.DestinationTableName = table.TableName;