使用格式将Exacel工作表导入到sql Server [英] Importing Exacel Sheet To sql Server with Format
问题描述
嗨
我已将Excel工作表导入具有完整格式的Sql服务器
那是
如果我的Excel工作表"包含段落"之类的记录，则Grid将显示带有Para
的记录
就像
详细信息
-----------
嗨
这是帕拉
假设我的excel表格上方包含详细信息"列，其条目如上述
然后我必须在段落中以相同格式在网格中显示相同条目
我已逐行执行简单导入-不起作用
批量插入-不起作用
尝试转换文本HTML格式然后保存到sql-找不到方法
如果有人知道，请帮助
在此先感谢
Hi
I have Import Excel Sheet To Sql server with Full Formatting
That Is
If My Excel Sheet Contain records like Paragraph Then Grid will be show records with with Para
like
Details
-----------
Hi
This Is Para
suppose above my excel sheet contain Detail column with entry like above
Then I have to show Same entry in Grid with Same Formatting of paragraph
I have do Simple Import row By row -Not working
Bulk Insert -Not working
Try To convert Text Html Format Then Save To sql - Not Found Way
IF anyOne Knows Than Please Help
Thanks In Advance
推荐答案
不确定您在问题中表示的格式，但是要从Excel检索数据并将其存储到SQL，您可以使用Excel Interop [ Excel OLEDB [
Not sure what formatting you mean in your question, but to retrieve data from Excel and store it to SQL, you can either use Excel Interop[^] or Excel OLEDB[^]. Of course, to be able to insert to the DB, you need to familiarize yourself with ADO.Net.
这篇关于使用格式将Exacel工作表导入到sql Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
