Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Basics
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 26th, 2010, 11:38 AM
Authorized User
 
Join Date: Feb 2008
Location: london, , United Kingdom.
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.
  #2 (permalink)  
Old August 27th, 2010, 02:40 AM
Friend of Wrox
Points: 2,473, Level: 20
Points: 2,473, Level: 20 Points: 2,473, Level: 20 Points: 2,473, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: India
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)
  #3 (permalink)  
Old August 27th, 2010, 08:05 AM
Authorized User
 
Join Date: Feb 2008
Location: london, , United Kingdom.
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..
  #4 (permalink)  
Old August 30th, 2010, 01:42 AM
Friend of Wrox
Points: 2,473, Level: 20
Points: 2,473, Level: 20 Points: 2,473, Level: 20 Points: 2,473, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: India
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.
  #5 (permalink)  
Old September 3rd, 2010, 12:50 PM
Authorized User
 
Join Date: Feb 2008
Location: london, , United Kingdom.
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.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 03:51 PM.


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