import mixed data from Excel using DTS

#1

We are using DTS to import data from excel 2003. The problem is some columns
has mixed data of number and text. Either the number data or the text data
are not imported. We have changed registry key "TypeGuessRows" to bo 0. Any
suggestions are appreciated.

#2

I use this article.

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Yeixn Huang" <Yeixn Huang (AT) discussions (DOT) microsoft.com> wrote

Quote:

We are using DTS to import data from excel 2003. The problem is some
columns
has mixed data of number and text. Either the number data or the text
data
are not imported. We have changed registry key "TypeGuessRows" to bo 0.
Any
suggestions are appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

import mixed data from Excel using DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

import mixed data from Excel using DTS - 10-13-2004 , 04:26 PM

Re: import mixed data from Excel using DTS - 10-14-2004 , 02:02 PM