将数据从Xl工作表导出到数据库
问题描述:
嗨
我在XL-sheet中加载了一些数据.我想将数据从XL-sheet导出到数据库...
谁能帮帮我.
在此先感谢
Hi
i have some data''s loaded in XL-sheet.I want to export the the datas''s from XL-sheet to Database...
Can anyone help me out.
Thanks in advance
答
当sql表列与excel工作表列匹配时,这可能会起作用.
如果不匹配,那么可以??????????
This might work when the sql table columns matches with the excel sheet columns.
If it doesnot matches then??????????
可以使用Import选项直接在数据库中.
步骤:
1.右键单击表名
2.选择任务
3.导入
4.在源代码中,从下拉列表中选择Microsoft EXcel
5.单击下一步
6.在源代码中提供sql连接并指定表名
7.从EXcel(Sheet1
This can be directly in database by using Import option.
Steps:
1.right click on the tablename
2.Select task
3.Import
4.In source select Microsoft EXcel from dropdown list
5.click next
6.In source give sql connection and specify the tablename
7.select the sheet u want from EXcel(Sheet1
)
中选择所需的工作表 8.单击下一步并完成
这样,来自Excel的所有数据都将加载到DB.
)
8.click next and finish
Thus all data''s from Excel is loaded to DB..