sqlserver引入 acess数据库

Question

rt

Answer 1

SqlServer企业管理器有这个功能，可以导出

Answer 2

http://database.ccidnet.com/art/1105/20070628/1127923_1.html

Answer 3

  string tname = comboBox2.Text;
            if (textBox1.Text != "")
            {
                string pd = openFileDialog1.FileName;
                string ocon = "provider=microsoft.jet.oledb.4.0;" + "data source=" + pd + ";" + "Extended Properties=Excel 8.0;";
                //SqlConnection con=new SqlConnection("data source=.;initial catalog=成绩,integrated security=true");
                OleDbConnection odcon = new OleDbConnection(ocon);
                string ocom = "select * from [sheet1$] ";
                OleDbDataAdapter oda = new OleDbDataAdapter(ocom, ocon);
                DataSet oset = new DataSet();
                DataTable dt = new DataTable();            SqlDataAdapter od = new SqlDataAdapter(@"select * from " + comboBox2.Text + "", con);
                SqlCommandBuilder scb = new SqlCommandBuilder(od);
                oda.Fill(oset, "[sheet1$]");
                od.Fill(dt);
                // for (int i = 0; i < oset.Tables["[sheet1$]"].Columns.Count; i++)
                // for (int j = 0; j < dataGridView1.Columns.Count; j++)
                if (comboBox2.Text == "班级")
                {
                    foreach (DataRow datarow in oset.Tables["[sheet1$]"].Rows)
                    {
                        DataRow datarow1 = dt.NewRow();
                        datarow1["班级编号"] = datarow[0];
                        datarow1["班级名称"] = datarow[1];
                        datarow1["系部"] = datarow[2];
                        dt.Rows.Add(datarow1);
                    }
                }
                  if (comboBox2.Text=="学生")
                 {
                     foreach (DataRow datarow in oset.Tables["[sheet1$]"].Rows)
                     {
                         DataRow datarow2 = dt.NewRow();
                         datarow2["学号"] = datarow[0];
                         datarow2["姓名"] = datarow[1];
                         datarow2["性别"] = datarow[2];
                         datarow2["系部"] = datarow[3];
                         datarow2["入学时间"] = datarow[4];
                         datarow2["班级编号"] = datarow[5];
                         dt.Rows.Add(datarow2);  
                     }
                  }
                  if (comboBox2.Text == "成绩")
                  {
                      foreach (DataRow datarow in oset.Tables["[sheet1$]"].Rows)
                      {
                          DataRow datarow3 = dt.NewRow();
                          datarow3["班级编号"] = datarow[0];
                          datarow3["课程编号"] = datarow[1];
                          datarow3["学号"] = datarow[2];
                          datarow3["成绩"] = datarow[3];
                          datarow3["学期"] = datarow[4];
                          dt.Rows.Add(datarow3);
                      }
                  }
                  if (comboBox2.Text == "课程")
                  {
                      foreach (DataRow datarow in oset.Tables["[sheet1$]"].Rows)
                      {
                          DataRow datarow4 = dt.NewRow();
                          datarow4["课程编号"] = datarow[0];
                          datarow4["课程名称"] = datarow[1];
                          dt.Rows.Add(datarow4);
                      }
                  }
//我这是将acess数据导入sqlserver，要从sqlserver导入到acess只需相应的改下

Answer 4

请问如何在sqlserver里面设置1-无穷多个的关系啊？一会儿给分