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 |
|
farzad
Starting Member
3 Posts |
 Posted - 2011-08-16 : 18:29:34
|
| How can I automate importing Excel files in SharePoint to SQL Server 2005?I would like to write a program to run as "scheduled task" by windows to perform this import periodically. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
farzad
Starting Member
3 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
farzad
Starting Member
3 Posts |
Posted - 2011-08-17 : 14:34:59
|
I am a newbie in SQL Server. Could you please step by step tell me how to:1. Set the UNC path2. Copy the files from SP to UNC path3. Export these files from UNC path to SQL Server dbI really appreciate your help in this matter. quote:
Originally posted by tkizer
You wouldn't import them, per se. You'd drop them off (copy) in the Sharepoint UNC path, and then Sharepoint would magically handle everything.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
From SharePoint to SQL Server