Last post Nov 15, 2016 06:15 AM by Eric Du
Nov 14, 2016 11:14 AM|kamal_kamal_1994|LINK
is it possible to store excel data in sql server without creating table?
Nov 14, 2016 11:22 AM|Mikesdotnetting|LINK
All data in SQL Server must be stored in a table somehow or other, so the answer is no.
Nov 14, 2016 11:26 AM|kamal_kamal_1994|LINK
thank you so much sir.. :)
Nov 14, 2016 11:31 AM|kamal_kamal_1994|LINK
i have data in excel sheet , can sql server arrange columns automatically depends on data it receives from excel sheet?? kindly answer me sir .
Nov 14, 2016 12:53 PM|0belix|LINK
Nov 14, 2016 01:07 PM|Mikesdotnetting|LINK
can sql server arrange columns automatically depends on data it receives from excel sheet??
Nov 15, 2016 06:15 AM|Eric Du|LINK
Firstly, I agree with mike's advice, I find one article written by mike, it use epplus, you can upload excel file, then transform file into data table, then insert them in database. For more details, you can refer to this article, here is article link:
The Best Way To Import Data From Excel To SQL Server via ASP.NET: