Depending on where you are in the process, that would either be the userid/password needed for the Access database or SQL. If it's Access, you will need the userid/password for the Access DB. If SQL, you should use the userid/password for either the DB owner or the sa account.

Also, what versions of Access & SQL are you using?

[edited by: LifeinAsia at 4:15 pm (utc) on Nov. 14, 2008]

i often import from access and as LifeinAsia said if you are at the point where it asks for the access user id and password you may find that there is none set in which case you can leave the fields
blank.

hi

Im importing from access to sql server.When i open access, i just enter a password and i dont enter any userid.
What could be the default thing that has to be entered