All,

Is there any relief from what happens when DTSing an Excel spreadsheet into
SQL 2000 and the zip + 4 values import as NULL?

Thanks.
--
jl

Are you seeing this

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

Allan

"John L" <JohnL (AT) discussions (DOT) microsoft.com> wrote

Allan,

I have tried solution #2 before and still got the same results as right now.
Rekeying would be painful since we are talking around 13,000 rows.
--
jl


"Allan Mitchell" wrote:

"John L" wrote:


YOU HAVE TO RE - FORMAT THE DATA IN EXCEL.

Best way that I have found -- is to
1) add 2 columns next to zip_code column. We'll call them column B and C.
Col A will be for Zip_codes. You will alos have the header row, so all work
will take place from row 2 to n (number of rows with data)
2) add ' (apostrephe) to B2 AND fill all down. You should see nothing, but
make sure you copy all rows down to match rows in column A (your zip_code row)
3) in cell C2 >> formula (concantenate) B2, then A2. ENTER
This will give you same data as A2 (appearance wise).
4) fill all data in column C down to row(n).
5) copy entire column C
6) PASTE SPECIAL AS VALUES to C1
7) Delete columns A & B (make sure your data in C is correct and filled all
down and is NOT formulas)
8) Add header back into C1.
Save file. >> Close file. DTS INTO SQL... This will now import varchar
rather than float values.

Thanks Matt.
--
jl


"mattb" wrote: