如何使用ASP在SQL Server中插入Excel数据

本文介绍了如何使用ASP在SQL Server中插入Excel数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

嗨 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