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.
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.
See http://sqlcetoolbox.codeplex.com/
RRR
Marked as answer by Angie xu - MSFT on Dec 14, 2012 01:34 AM
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
kookoomoo
Member
54 Points
92 Posts
Importing Excel File into Sql Table
Dec 07, 2012 12:05 PM|LINK
Hello,
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.
Thanks!
rrrsr7205
Participant
1304 Points
313 Posts
Re: Importing Excel File into Sql Table
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.
See http://sqlcetoolbox.codeplex.com/
bhaskar.mule
Contributor
2270 Points
659 Posts
Re: Importing Excel File into Sql Table
Dec 07, 2012 01:30 PM|LINK
hi,
refer this link
http://csharpektroncmssql.blogspot.com/2012/09/import-excel-data-into-sql-server-how.html
Site:Rare technical solutions
rrrsr7205
Participant
1304 Points
313 Posts
Re: Importing Excel File into Sql Table
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
GmGregori
Contributor
5446 Points
735 Posts
Re: Importing Excel File into Sql Table
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.
wavemaster
Participant
1279 Points
1127 Posts
Re: Importing Excel File into Sql Table
Dec 08, 2012 02:51 PM|LINK
RRR
Are you saying that with SQL Management Studio you can not connect to SQL CE databases?
Robert
rrrsr7205
Participant
1304 Points
313 Posts
Re: Importing Excel File into Sql Table
Dec 08, 2012 04:59 PM|LINK
Yes, I am saying that (with respect to SQL Server CE V4.0)