如何拆分Excel工作表的单元格并将其保存到数据库的不同列中
问题描述：
Hello SIr
请帮帮我。我想拆分excel的单元格并将其保存到不同的柱中。
我想拆分列：111000/2008。
我想保存注册号= 111000
过去年份：2008。
请帮助。我需要将它保存在数据库中
Hello SIr
please help me. I want to split the cell of excel and save it into different columne.
I want to split column: 111000/2008 .
I want to save registration number=111000
passing year:2008.
Please help. I need to save it in database
答
要做的步骤：
1.创建OleDbConnection [ ^ ]并使用 ConnectionString [ ^ ]如下：
Steps to do:
1. Create OleDbConnection[^] and use ConnectionString[^] as follow:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";
2.创建OleDbCommand：
2. Create OleDbCommand:
SELECT LEFT([FieldNameOrColumnNo], LEN([FieldNameOrColumnNo]-5) AS RegNo,
RIGHT([FieldNameOrColumnNo], 4) AS PassYear
FROM [SheetName
3.创建并执行OleDbReader [ ^ ]
4.创建 DataTable [ ^ ]和从OleDbReader加载数据 [ ^ ]。
5.这就是全部！
3. Create and Execute OleDbReader[^]
4. Create DataTable[^] and load data into it from OleDbReader[^].
5. That's all!