Hi,

I'm importing Excel file into SQL sever.
At the Column Mappign and Transformation screen, I see
that the Destination Field Name didn't follow the Excel
Column Names at all.

Also the data type is nvarchar and size is 255 despite
Excel column width being changed to less than 255.


Does anyone know if there's a solution to the Field
Name ,Data Type and Size issue ?

When you "Define" the destination you can change the definition.
nvarchar(255) is the default.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"El" <elmoemail (AT) yahoo (DOT) com.sg> wrote

Thks Allan..

but I like to konw is this the only way (meaning manually
change each of the fields in the table..there could be
many fields in a table) ?

In general cells in an Excel Spreadsheet are formatted as General. If you
format the cells to the datatypes you require then the driver is a lot
better at picking a better datatype for the destination


also look at

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

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

<anonymous (AT) discussions (DOT) microsoft.com> wrote