Hi all

I am trying to import some data from Access to SQL 2005 via a SP. It is on an Ad hoc basis so I can't DTS it in. I have a problem though. The access database file has a password and using the stored procedure with OpenRowSet, I can't get it to accept the password and therefore can't get to my data! The ironic thing is I can get to it fine in Crystal Reports so I'm actually contemplating droping it into excel and then uploading but its a lot of mess for something that should be simple.

Anybody dealt with this before?

Thanks in Advance