problems loading data

[treviboy]

hi,

I am having a terrible time loading data into a table.
Im loading from an Excel spreadsheet. The fields with problems are defined as "tiny ints" in sql 2000....
But my fields are numbers, but I guess they're not small enough and it wont accept them. How do I tell Excel to make it a tiny int??? Or, if I put this in Access, I dont see wehre I have tiny int as an option. Any ideas??????? thanks

 

[mrdenny]

When using SSIS you have to use a datatype conversition task to convert the data from text to numeric for loading.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com