Yes the spreadsheet has the passwords

Thanks I will try this.

Just one point I am creating database logins not windows.

In script can I just remove the Create Logins from Windows, will this just create the user...

Sorry being new to sql script

I have looked at the examples but it do not show how to import from another database.

After i created the tempory one

which table do I import sql logins into?

Can you use BCP to import users sql logins?

Can this script be amended so it will read a spreadsheet with a list of

Username, password database access?