Sql Add table from other database with password

[lkmaurik]

Hello All,

Well, I want to clone a table from an other database in my database.

Normally I will use the sql:

INSERT INTO calibration


SELECT * FROM [C:\FlexMeasurement\Calibration.accdb].[calibration]

But now the databse I want to open has a Password. How do I add this password to myn sql string.

Thank you in advance

[NTC]

are you able to link to the table - and then view its data?

[lkmaurik]

Dear NTC,

I'm not sure what you mean.

I already use an ole db connection. This connection is the target database. So the database where the cloned table need to come. I'm using an program that only understand .net and sql.

I'm not sure if i answered your question now?