It didn't like @WDA smallint, so I had to change to nvarchar(2). I ended up taking out the 'region_id= ' in all the sql statements and dumped all regions...

Sounds good. I'll have to play with it. Probably won't have anything until late next week. I'll be out of the office M-W.

Not sure I...

I did set it up that way. Still got chopped. Thanks.

Thanks again. I got it working, but unfortunately, my sql statements exceeded what nvarchar will hold for the @sql parameter. I just gave you a portion of the...

Thanks Adam. Where do I pass in the worksheet name? This is a portion of my sp:

Create procedure spAttendanceWDA (@WDA smallint)

as

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=(path)\TEST.XLS;',

'SELECT * FROM [Sheet1$]')

Select PY,...