>.. or the more sophisticated solution would be to use Automation to throw the data in.
sophisticated maybe, but with this amout of data a ton slower. I would go with the import and then just automate any formating. Better still is if the format is always going to be the same set up a 'template' excel sheet to import into and then the formating would already be done.
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com