p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ASP.NET 3.5 Basics (http://p2p.wrox.com/forumdisplay.php?f=351)
-   -   importing data from Excel in Visual Studio 2008 (http://p2p.wrox.com/showthread.php?t=80693)

murshed August 26th, 2010 11:38 AM

importing data from Excel in Visual Studio 2008
 
Hi,
I've tried to find a thread answering this query but had no luck.

I want to import a few columns of data from an Excel spreadsheet into the SQL tables that form the database for my website project.

Unlike with Access, I cannot find any import solution within the application... anyone got a solution?

Thanks.

om_prakash August 27th, 2010 02:40 AM

if this is one time activity then you can use SQL server import export option to import data from excel.

murshed August 27th, 2010 08:05 AM

Hi Prakash, thanks for your reply.

Yes, it is a one-time transfer of data over to the website back-end. My problem is further complicated by the fact that I'm working with SQL Server Express and have no access to a stand alone program for importing/exporting data in SQL Server Express.

I read in several places about this import wizard but I just don't seem to have it as part of my install. I have a couple of SQL Server 2005 tools installed, the Surface area configuration manager and the Server configuration manager, neither of which provides an avenue for importing data into a table.


is there some programmatic way in which I could read data from the spreadsheet and INSERT into the table columns?

om_prakash August 30th, 2010 01:42 AM

yes, you can read the excel file and insert the data in sql table..

If you are using asp.net then please check the following link:
http://www.dotnetspider.com/resource...e-asp-net.aspx

murshed September 3rd, 2010 12:50 PM

Hi Prakash, thanks again for the help.
I think that should work for me. I'm also going to try out the latest beta of SQL Server, maybe it comes with some management tools. It really is puzzling that Visual Studio 2008 doesn't provide a simple way of doing data importing jobs.


All times are GMT -4. The time now is 12:30 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.