I am creating Linked server on SQL Server. I would like to load data from Access database to SQL server tables.

Thanks for your quick response. I got how to prohibit save and execute DTS packages. I do not know how to restrict creating of packages and run them without saving....

It works! Thanks!

If I do this way I get additional information: date, time, size….

Is there any way to get only file names?

I have to load into table just file names. How to...

Thanks for your help!

quote:

---

What does it mean the standard login? Should I use SQL Server authentication?

---