Importing Excel to Sql Server

		Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Importing Excel to Sql Server

ADO.NET For discussion about ADO.NET.Â Â Topics such as question regarding the System.Data namespace are appropriate.Â Â Questions specific to a particular application should be posted in a forum specific to the application .

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

March 20th, 2007, 03:33 PM

dowens3rd

Registered User

Join Date: Aug 2006

Posts: 3

Thanks: 0

Thanked 0 Times in 0 Posts

Importing Excel to Sql Server

I am haveing major problems trying to upload an excel spreadsheet into a SQL Server table on a vb.net web appllication. I have seen many posts on this topic, but no one really answers it. I have done it by reading the excel file into a dataset and then inserting each line into a table, but I have file over 50,000 rows and this takes way to long. somebody please help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing from SQL Server to test site	Aldark	SQL Server 2000	4	June 4th, 2007 10:52 PM
Importing data into SQL Server 2005 Express	rit01	SQL Server 2005	1	March 22nd, 2007 02:23 PM
problem in importing data from excel to sql	hiren1977	General .NET	0	January 2nd, 2007 06:00 AM
Importing datas to SQL Server. Need suggestions!	Fly4High	SQL Server 2000	2	August 8th, 2006 02:10 PM
Importing Excel to SQL replaces values to NULLS	smujib	Classic ASP Basics	0	February 19th, 2006 09:02 PM