Help with Excel data pump

#1

I am having problems importing text values from an Excel file. Numeric
fields are loading fine, however. Below is what my spreadsheet looks like

APP_AGE
1 1
2 2
3 3
4 4
5 5

I am doing a straight copy column into a table and the fields are of type
varchar for the first column and int for the 2nd column. In the table my
data is looking like this

NULL NULL
1 1
2 2
3 3
4 4
5 5

Why am I have troubles importing any text values? Any help is appreciated.

Thanks

#2

Probably because of this

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

Allan

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

Quote:

I am having problems importing text values from an Excel file. Numeric
fields are loading fine, however. Below is what my spreadsheet looks
like

APP_AGE
1 1
2 2
3 3
4 4
5 5

I am doing a straight copy column into a table and the fields are of
type
varchar for the first column and int for the 2nd column. In the table
my
data is looking like this

NULL NULL
1 1
2 2
3 3
4 4
5 5

Why am I have troubles importing any text values? Any help is
appreciated.

Thanks

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

Help with Excel data pump

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

Help with Excel data pump - 11-15-2005 , 09:31 AM

Re: Help with Excel data pump - 11-15-2005 , 02:32 PM