I have an asp.net web site which uses a bulk insert to insert a large number of records into a SQL server (2008) database.
I'm now migrating this application to a vb.net application. I'm trying to avoid uploading large txt files to the sql server in order for the bulk insert to work. I'd like to have the txt file on the client machine. the problem is that when I specify the text file (for the bulk insert) on the client machine, I get an error saying that the file could not be found, due to the fact that the server is expecting the file on it's own file system.
The way the system works is this. The user specifies a an excel spreadhseet which is read by the application. It may contain several thousand records. I then want to insert the records into a sql server database. I want to avoid iterating through a datatable and using an insert query for each row in the datatable, as it just takes too long. On the web based system (IIS and SQL server on the same server) the datatable is written to a text file and then the text file is used for a bulk insert. I'd like to read the spreadsheet into a text file on the client, but cannot use this for the bulk insert as the server cannot recognise the file.
Is there a way of using a data source text file which is not on the sql server, other than using shared folders? Alternatively is there ano
View Complete Post