Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 08, 2012 04:59 PM by rrrsr7205
Dec 07, 2012 12:05 PM|LINK
Would anyone be able to point me to a good tutorial on how to import data from an excel file a user would upload into a sql table? I am programming in web pages and using Razor.
Dec 07, 2012 01:13 PM|LINK
You didn't say it, but I assume you are using SQL Server CE 4.0.
Codeplex has a very nice approximation of SQL Server Management Studio that can be used to manage SQL Server CE 4.0 databases. It includes a function to import data from a "csv" file to a table.
Dec 07, 2012 01:30 PM|LINK
refer this link
Dec 07, 2012 01:38 PM|LINK
Depends upon whether he is using SQL Server or using SQL Server CE. The link to blogspot.com assumes the former. The link to Codeplex assumes the latter
Dec 07, 2012 03:46 PM|LINK
Some months ago I posted an article on how to export data from Sql Ce to Excel:
Export data to Excel in Webmatrix.
Even if it addresses the opposite function, you could find some clues, maybe in conjunction with other posts like this one:
Import Data From Excel to Access with ASP.NET.
Dec 08, 2012 02:51 PM|LINK
Are you saying that with SQL Management Studio you can not connect to SQL CE databases?
Dec 08, 2012 04:59 PM|LINK
Yes, I am saying that (with respect to SQL Server CE V4.0)