How to Import Excel Data to Access Database
Hi,
Does anyone of you know how to import an excel sheet data into Access Database, SQL Server using ASP.NET (C# preferance).
Any ideas and inputs will be helpful. I can upload the excel file to the web server and even read the data from the excel sheet into a datagrid control on the web form.
But I am not able to insert that data into an Access table. Your help would be very much appreciated !!!!!
Thanks
Ray