Dear Musassar
Thanks for the code on page : http://www.aspsnippets.com/Articles/Copy-and-paste-data-from-Excel-Clipboard-to-GridView-in-ASPNet.aspx.
How can I make one of the column (eg.Name) from this Grid that is generated by copy paste method as a criteria in a SQL query statement. It seems that prooper referencing was needed when I attempted unsuccessfully several times.
Would it be any of the following:
e.g. Select [Name] from [MyCustomers]
where [MyCustomers].[Name] = __________
or
Select [MyCustomers].[Name] from [MyCustomer] inner join_____________ON______________
Please help since I am a beginner.
Thanks
Asif