如何使用ASP在SQL Server中插入Excel数据 [英] how to insert a Excel data in SQL server using ASP
问题描述
嗨
i希望使用ASP从Excel文件中将数据插入SQL Server
plz帮助我
hi
i want to insert a data into a SQL Server from Excel file using ASP
plz help me
推荐答案
hi
i希望使用ASP从Excel文件中将数据插入SQL Server
plz帮帮我
hi
i want to insert a data into a SQL Server from Excel file using ASP
plz help me
===
嗨
我也有同样的问题。但我尝试使用DTS将excel文件导入SQL，并在选择源文件驱动程序时，它给出了错误，并选择了无效的驱动程序。我使用了excel 5/4 / 3,97-2000，提到的所有选项 - 但没有工作
-Tanya
===
Hi
I have the same question too. But I tried using DTS to import the excel file to SQL, and while selecting the source file driver- it gives and error that its an invalid driver selected. I used excel 5/4/3, 97-2000, all options mentioned- but didnt work
-Tanya
Tanya，（和这个也适用于Yogesh）
告诉我到目前为止你有什么。另外，excel文件的数据格式是什么？你如何组织桌子？
Jared
Tanya, (and this goes for Yogesh, too)
Show me what you have so far. Also, what is the data format of the excel file? How do you have the tables organized?
Jared
Tanya，（这就是对于Yogesh来说也是如此）
告诉我你到目前为止所拥有的东西。另外，excel文件的数据格式是什么？你如何组织桌子？
Jared
Tanya, (and this goes for Yogesh, too)
Show me what you have so far. Also, what is the data format of the excel file? How do you have the tables organized?
Jared
嗨Jared，感谢您的关注。
这是我必须要做的事情：
我有四个表，如我最近的问题-sql1，sql2，sql3，sql4-这些都是excel文件。这些表格中的数据是charecters，intergers等...
喜欢电子邮件ID，帐号，姓名等...
现在我已将这些文件复制到sql server桌面和启动的dts向导
它要求我选择文件...在数据源类型中 - 选择为excel 3.0
并点击下一步 - 它转到目标类型 - 选择我们的sql server ...
然后说无效输入数据源连接类型....
所以 - 我不确定，如果还有其他方法将所有excel文件导出到sql ..server 2000.我在google中看到了一些代码，用于将数据从excel移动到sql，但它应该在哪里运行，在服务器端？
请建议
Tanya
Hi Jared, Thanks for your interest.
Here is what I have to do:
I have four tables, as posted in my recent question- sql1,sql2,sql3,sql4- which are all excel files. Data inside these tables are charecters, intergers etc...
like email id, account number, names etc...
Now i have copied these files to the sql server desktop and launched dts wizard
It asked me to choose files...in data source type- selected as excel 3.0
and clicked on next-- it went to destination type- selected our sql server...
it then says invalid input data source connection type....
So- I am not sure, if there is any other way of exporting all the excel files to sql ..server 2000. I saw some code in google for moving data from excel to sql, but where should it be run, on server side??
please suggest
Tanya
这篇关于如何使用ASP在SQL Server中插入Excel数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
