My users upload excel files to a folder on the web server. I execute a sproc on the sql server that uses openrowset to open the excel file and import the data into a db table.
All of this works great when the sql server and the web server are on the same machine (dev environment) but not when they are separate.
I found a post that described using ftp in the filepath to grab the file but i have been unable to make this work.
The webserver has ftp access turned on for the location where the files are uploaded and i have been able to access the file using the ftp://userid:[email protected] construct
Any ideas or thoughts on this or how it could be done differently. Thanks Scott