hello to all
i want to give the functionality in web site that a user can upload excel file which contains the name and phone number.
i want my program read that file and put the records in my database.
although big! but please give me some solution.

regards,
munish


thanks......

__________________
thanks......

You can use the Jet driver in the OleDbConnection class to connect to the spreadsheet. That will allow you to read in the information in the spreadsheet into a data table or whatever data structure you want, and from there you can insert the data into your database. I recently tried out the SqlBulkCopy class, which worked really well, and was faster. You could also iterate through your data table and insert one row at a time if thats your preference. Good luck!

Here is a link to an article on SqlTeam.com that I found really useful in explaining how to use SqlBulkCopy if you go that route:

http://sqlteam.com/item.asp?ItemID=26941

Thanks A lot i will try today.

regards,
munish

thanks......

mate if u found anything useful can you please post it :)

i have a problem which is similar to urs (a bit more complicated :s ) but with the same concept :)

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"