Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2012-05-14 : 11:57:49
|
| Hi All,I have to upload around 100 Excel files in SQL Server 2000 which are having password. I know the password, is there any way i can upload thisPlease help |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2012-05-14 : 12:32:17
|
| In SQL server 2000 you have to use the DTS package to load the Excel file Or Export and import wizard.In SQL 2005 or above you can use SSIS packages and Export and import wizard.Vijay is here to learn something from you guys. |
 |
|
|
sanjay5219
Posting Yak Master
240 Posts |
Posted - 2012-05-14 : 12:49:16
|
| But i want top automate the password concept |
|
|
|
|
|
|
Upload Excel FIle