如何在不使用sqlbulkcopy类或sqlserver导入/导出向导的情况下动态导入excel文件(.xls& .xlsx)到sql server 2000 [英] How to Import excel file (.xls &.xlsx) into sql server 2000 dynamically without using sqlbulkcopy class or sqlserver import/export wizard

查看:55
本文介绍了如何在不使用sqlbulkcopy类或sqlserver导入/导出向导的情况下动态导入excel文件(.xls& .xlsx)到sql server 2000的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

Hi Buddies,



由于我是VB.net的新手,任何人都可以指导我理解在Excel中将excel文件上传到sql server 2000的编码。净。我需要对此进行简要说明。请回复我作为一个程序,以便它易于理解并帮助我增强它。我在等你的回复。请联系我@ surae31@ymail.com/8122149820

Hi Buddies,

Since I'm new to VB.net, can anyone guide me to understand the codings for uploading excel file into sql server 2000 in VB.Net. I need brief explanation on this. Kindly response me as a procedure so that it is easy to understand and help me to enhance it.c I'm waiting for your replies. contact me @ surae31@ymail.com/8122149820

推荐答案

尝试:



http://www.aspsnippets.com/Articles /Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx [ ^ ]



http:// www.codeproject.com/Questions/442596/Importing-excel-workbook-into-sql-server-in-vb-net [ ^ ]
Try:

http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx[^]

http://www.codeproject.com/Questions/442596/Importing-excel-workbook-into-sql-server-in-vb-net[^]


这篇关于如何在不使用sqlbulkcopy类或sqlserver导入/导出向导的情况下动态导入excel文件(.xls& .xlsx)到sql server 2000的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆