I'd have to see a sample of how the data is put together before I could suggest anything. That and I'd need to know what method you are using for the import (Import Wizard, SSIS, OpenRowset, something else?).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon