Join | Login | Why Join?

Access to 501 free guest articles, discussions and more, just create your free SSWUG User ID:

Email address:

This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Read an EXCEL FILE into SQL Server

Article Abstract:

(Eli Leiba) The following procedure reads an EXCEL xls file into a result set in SQL Server by using the opendatasource buildIn system rowset function.

Read this article...

Related Articles - For Members.

	All Articles By Author
	Load Impact of SQL Profiler 2000
	Generate Next Numbers with SQLServer
	Prioritize your Work Load (Finding Low Hanging Fruit)
	Moving to DB2 9: Considerations and Migration Part 2
	How to Choose the Best Connectors for SSIS
	Use an ActiveX Script in your DTS Package
	What To Do When you need to compare databases.
	Simplify Data Entry user experience with AutoComplete

Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc. (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004

		*Search* SSWUG: