How to export or import data to and from sql server 2008 via visual studio 2008?

Question

0.00/5 (No votes)

See more:

, +

Dear Coders,

I would like to have some help regarding the following actions:

1) Export Data from Visual Studio to Text file.
2) Export Data from Visual Studio to Excel Sheet.
3) Import Data to Visual Studio From Text File.
4) Import Data to Visual Studio From Excel File.

I surely need help regarding this...

Posted 23-Oct-12 3:08am

armarzook

Add a Solution

Comments

joshrduncan2012 23-Oct-12 9:09am

What attempts have you made in regards to accomplishing this task so far?

armarzook 23-Oct-12 9:19am

I really have no idea regarding this and I am a novice to visual studio and SQL server.. I really need help...

joshrduncan2012 23-Oct-12 9:26am

We will not do the work for you. This forum is designed to assist with issues in existing code that are preventing a task from being successfully completed. I strongly urge studying Visual Studio (2010/2012) and SQL Server and how to import/export to and from Excel. Have you tried researching material on google/bing before asking this question?

armarzook 23-Oct-12 9:34am

Doing researching for the past one week but till now only got to know how to export and import Data from SQL server directly... still didn't get a clue for that In visual studio...

OriginalGriff 24-Oct-12 6:24am

You need to improve your question!
Change the tags: the basic thrust of your problem has nothing to do with SQL, or reporting - it is to do with writing code to save information. As such, we need to know what language you are trying to work in - VB? C#? C++? ... - (so we don't confuse you by giving you a solution in the wrong language) and also what you have tried so we don't talk you through what you have done already.

How you save data depends on a lot of factors: what kind of data it is is a major one of them!
Use the "Improve question" widget to edit your question and provide better information.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Corporal Agarn · Answer 1 · 2012-10-24T09:09:00

Solution 2

I believe a book on .NET programming will cover the basics as there is not a quick answer. I assume you are reading from a SQL Server and what to input/output from/to the file types listed. When looking for a book look for input / output or IO chapters.

Posted 24-Oct-12 9:09am

Corporal Agarn

Updated 24-Oct-12 9:10am

v2