Solved

ASP.net import data from Excel to SQL table in project

Posted on 2011-02-28
3
366 Views
Last Modified: 2012-06-27
Hi

I have an ASP.net 4 project with a SQL Server 2008  database in my project as shown in the image below. I need to get Excel data into Table1. What is the easiest way to do this using the GUI. Do I right click somewhere? Just need a straightforward data to get extra data into my table easily.
Thanks ASP Project image
0
Comment
Question by:murbro
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
Comment Utility
right click the database, tasks, import data...

follow the wizard, should be straight forward
0
 

Author Comment

by:murbro
Comment Utility
Hi. Thanks but right clicking on the database gives me the options shown in the new image below
but none of these are what you mentioned. Where to from here
 right click
0
 

Author Closing Comment

by:murbro
Comment Utility
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now