在sql ser 2008数据库中导入Excel工作表 [英] Import Excel Sheet in sql ser 2008 database

问题描述

Hello Professional



有一种情况我需要将数据从Excel工作表导入到Sql server 2008数据库

i试用谷歌也实现了如此封闭的编码结构，但仍然需要进行故障排除。



仍然发生的异常是： - Microsoft Jet数据库引擎可以找不到对象'Sheet1 $'。确保对象存在，并且你正确地拼写它的名字和路径名。



有一件事你真的需要知道我是使用Microsoft企业库

在ma项目中...



欢迎任何欣赏，但没有其他网站的链接（特别是如果你自己没有练习在...）





先谢谢

Hello Professional

there is a case where i need to import data from Excel sheet to Sql server 2008 data base
i tried on google also got so closed coding structures also implemented but still its need to troubleshoot.

still the exception that is occurring is :-The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.

and one thing that is really you need to aware that i am using Microsoft Enterprise Library
in ma project...

any appreciation is welcomed but without other website's link (specially if you yourself not practiced on that)...


Thanks in Advance

推荐答案

。确保对象存在，并且你正确地拼写它的名字和路径名。



有一件事你真的需要知道我是使用Microsoft企业库

在ma项目中...



欢迎任何欣赏，但没有其他网站的链接（特别是如果你自己没有练习在...）





先谢谢

'. Make sure the object exists and that you spell its name and the path name correctly.

and one thing that is really you need to aware that i am using Microsoft Enterprise Library
in ma project...

any appreciation is welcomed but without other website's link (specially if you yourself not practiced on that)...


Thanks in Advance

嗨！请参阅本文。我希望它会对你有所帮助。谢谢。

Hi! See this Article. I hope it will help you. Thank You.

我在几天之前遇到了同样的错误...



请确保 <您传递的code>路径 与您浏览文件时的路径相同...

i had a same error before couple of days...

Please Make sure that path you are passing is the same path from were you are browse the file...

这篇关于在sql ser 2008数据库中导入Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！