Hi,

I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget
using Microsoft JET database engine, but it gives me an error saying
" Workgroup information file is missing or opened exclusively by another
user"

This error only exists if i use an MS SQL login with a password but it works
fine with a login without a password. My question is, is there a way around
this with a login that has a password?

Thanks

Do any of these posts help you?

http://groups.google.com/groups?q=%2...r=&sa=N&tab=wg


"Tina" <Rumi_Akani (AT) yahoo (DOT) com> wrote

Sadly no

These posts largely refer to importing or exporting from Access.

This is an import from Excel into a SQL 2000 database....


Any ideas ?
Thanks

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Same engine though right and kind of same idea. Is the spreadsheet
password protected?

Allan



"Tina" <Rumi_Akani (AT) yahoo (DOT) com> wrote

could be a rites issue on the system.mdw file?