Import a Text File, NOT using BULK INSERT or OPENROWSET, to Sql Server - Web Server

Hi Experts,

I would like to import a text file, the fastest way possible, without using BULK INSERT or OPENROWSET as the SQL Server doesn't have access to the webserver for security reasons.

So. I was thinking of using something like Microsoft Text Driver to Select the Values into a DataSet and then use the DS to INSERT the values into a Table in the SQL Server?
Thoughts?
Code Examples? I am having some issues with Text Driver and the Web Application at the moment...

Thanks

C

Example Conn String Used
Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;
 
Error Returned
Data source name not found and no default driver specified

Select allOpen in new window