Getting NULL value when Importing spread sht to sql table

[cdavii]

Anyone have an idea why i get null values when i import data from a ms spread sheet in a sql tbl. The table elemet(Spread sheet) in question contains alpha numerics. The sql table is populated with "NULL" when the value is numeric only. Example: A-ASP21A1-- imports perfect
6500012111-- results in "NULL" in the sql table element

[drhowarddrfine]

This should be moved to the proper forum but not sure which one.

[kadghar]

This should be moved to the proper forum but not sure which one.

Since its an MS spreadsheet, i would say he migth be using SQL Server as well.

[imtmub]

Change the sql table field type to nvarchar.

Use this statement to import from excel. I got the same kind of data and imported from excel.
[CODE=SQL]Select * Into[dbo].[table]
FROM OPENROWSET('Mic rosoft.Jet.OLED B.4.0',
'Excel 8.0;Database=C: \Documents and Settings\admin\ Desktop\excel.x ls;IMEX=1',
'SELECT * FROM [Sheet1$]')[/CODE]

[ck9663]

Anyone have an idea why i get null values when i import data from a ms spread sheet in a sql tbl. The table elemet(Spread sheet) in question contains alpha numerics. The sql table is populated with "NULL" when the value is numeric only. Example: A-ASP21A1-- imports perfect
6500012111-- results in "NULL" in the sql table element

what's the data type of the target table?

-- ck

[jhardman]

what's the data type of the target table?

-- ck

Are you just importing with SQL Server?