In my ASP the user must upload a catalog in excel file, and the problems I have are two:
1) I don't know if the user is uploading the excel template I provide (cannot be any excel file). How can I check if the excel file is the right one?
2) I am updating record to records, and the server crash if the user upload a catalog with 10,000 items. I know I can upload the catalog using INSERT INTO - SELECT *, but in the same database (in this case, I have the SQL Server connection and the EXCEL connection). Is it possible to upload the 10,000 items in one time?
Best regards, and thanks!!
Pablo (sorry for my english