Importing Excel to SQL replaces values to NULLS

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
Importing Excel to SQL replaces values to NULLS

Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics 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

February 19th, 2006, 09:02 PM

smujib

Authorized User

Join Date: Feb 2005

Posts: 21

Thanks: 0

Thanked 0 Times in 0 Posts

Importing Excel to SQL replaces values to NULLS

Hi,
I am using SQL Server 2000 DTS to import data from a excel file to a SQL Server table with a column of type varchar. For some reason the DTS is replacing all the values to NULL in the table. The type in excel is General.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sending NULLs into a SQL Server PROC	lisabb	ASP.NET 2.0 Basics	1	June 21st, 2007 03:36 PM
Importing Excel to Sql Server	dowens3rd	ADO.NET	0	March 20th, 2007 03:33 PM
problem in importing data from excel to sql	hiren1977	General .NET	0	January 2nd, 2007 06:00 AM
Importing from Excel	bmains	ADO.NET	1	October 9th, 2004 11:44 AM
MS Excel(Importing)	S Kamran	Access	1	October 29th, 2003 06:55 AM