Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Basics
|
ASP.NET 3.5 Basics If you are new to ASP or ASP.NET programming with version 3.5, this is the forum to begin asking questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 26th, 2010, 11:38 AM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default 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.
 
Old August 27th, 2010, 02:40 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

if this is one time activity then you can use SQL server import export option to import data from excel.
__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.
The Following User Says Thank You to om_prakash For This Useful Post:
murshed (August 27th, 2010)
 
Old August 27th, 2010, 08:05 AM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default

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?

Last edited by murshed; August 27th, 2010 at 01:18 PM..
 
Old August 30th, 2010, 01:42 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

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
__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.
 
Old September 3rd, 2010, 12:50 PM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual studio 2005(32 bit) code not work in visual studio 2008 on windows server 2008 gr8.jain Visual Basic 2008 Essentials 1 August 31st, 2009 10:07 AM
Can I use Visual Studio 2008 Kevin7777 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 25 March 7th, 2009 08:27 AM
very new to Visual Studio 2008 Joel Saren Visual Basic 2008 Essentials 2 June 6th, 2008 03:27 PM
Does Visual Studio 2008 contains .NET3.5? sikanderwaheed C# 1 March 30th, 2008 04:41 AM
Visual Studio 2008 looks juzjess Intro Programming 0 October 26th, 2007 03:35 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.