export excel data to sql server table. using odbe Method. it done that and it working fine in local machine. but it not working online. after i deploy it in server. in Server does not has the excel.
Gopi nath
Hi, Instead you can use the CSV file. CSV is the comma separated file which can be treated as simple text file or Excel CSV file. So you can export the CSV data to SQL Server while opening and reading the file as simple text. Hope that helps.