using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data;
namespace Excel.ADO.Net
{
class Program
{
static void Main(string[] args)
{
// 適当なファイル名を入力
string path = Console.ReadLine();
using (var conn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0;"))
{
conn.Open();
using (var command = conn.CreateCommand())
{
// テーブルを作って
command.CommandText = @"create table Person(
ID int,
Name nvarchar(255)
)";
command.ExecuteNonQuery();
}
foreach (var i in Enumerable.Range(1, 100))
{
using (var command = conn.CreateCommand())
{
// データの登録
command.CommandText = "insert into [Person$](ID,Name) values (?, ?)";
command.Parameters.Add("@id", OleDbType.Integer).Value = i;
command.Parameters.Add("@name", OleDbType.VarChar).Value = "太郎no" + i;
command.ExecuteNonQuery();
}
}
conn.Close();
}
}
}
}