SSMS 18.4 import data wizard excel to SQL client 11.0, SQL server authentication. No pswd field

Copper Contributor

When trying to import an excel file from local PC to a private cloud SQL, the user can log into the sql database with no problem. 

They run the SQL import data wizard for their database with source file excel, destination is SQL Server Native Client 11.0 with SQL Server Authentication.

The user name field displays, but not the password field. So they can't log in to import the file. 

 

I haven't found any answers online yet. Any ideas out there?

Thanks

0 Replies