What I'm really looking for is the ability to bulk import for a delimited file (tab probably). Currently I'm having to clear the table and use DTS with a custom script to do this and just havign the functionality within the module would be much nicer and allow me to farm out this work to the guy actually creating the quote list.
Thanks,
Shaggy
I never like to clear a table while online as it will not be a nice experience for users at the time of update. Are you on a hosted server? How many records are you talking about? How different is your data from one upload to another? Can you update/insert/delete from a subset of your data (ie preprocess some of the data to reduce the number of records uploaded.)? Can you convert the data to XML (SQL Server can load XML into a row set which can join with the database tables) before uploading. There may also be other options available if this is product information that you are uploading. Can you describe in more detail what you are doing so that we can get a better understanding of your requirements.
Oops. Sorry, I wasn't thinking of Scott's quotes module, I thought the reference was to uploading quoting data (as in products). Along with web development, I do a lot of product data conversion/manipulation and I misread the question,