Password in SQL

[grassaj]

I would like to update a table with data in another database; the other database has a password protection. Can I put the password in my SQL statement so I can get the data?

Here's my statement right now:

INSERT INTO tblData SELECT * FROM tblData IN '" & strFileName & "'"

Thanks!