Export Data in MS Visual studio to Excel

[happydays886]

Hey All,

I'm having a wonderful time trying to do this and I don't know where to begin.

I'm trying to export data I pulled from tables using MS Visual Studio to Excel. One approach the internet is telling me is to (1) export this to GridView (2) then Export GridView to Excel? I'm not sure if that's correct, but I thought I'd throw it down as something I'm looking into (without success).

I could use some help on how to do this.

Thank you,

HD

[Kyle123]

What language are you using in visual studio? How are you pulling the data? What environment are you running the code in? Is this a desktop application or a web application?

[happydays886]

I am using SQL (SELECT / FROM/ WITH)

I have very basic SQL knowledge - but I'm learning. I accessed a dbo. file and pulled a selection; now I'd like to export that selection to excel.

[Kyle123]

You aren't helping us help you, please answer the other questions

[happydays886]

What language are you using in visual studio? How are you pulling the data? What environment are you running the code in? Is this a desktop application or a web application?

What language are you using in visual studio?
- SQL

How are you pulling the data?
- from an SQL Query: SELECT all* FROM dbo.xxx WITH Division = 'division name'

What environment are you running the code in?
- MS Visual Studio's SQL input plane

Is this a desktop application or a web application?
- Desktop application (MS Visual Studio)

[Kyle123]

Are you using Visual Studio or SQL server management studio?

[happydays886]

Are you using Visual Studio or SQL server management studio?

Visual studio

[Kyle123]

Why not just copy and paste it?

[happydays886]

Well, that worked... jfc.

Assuming I have a lot of data, is there anyway I can export?

[Norie]

Do you need Visual Studio to get the data?

[happydays886]

Yes.

In a nut shell, I want to run some reports and SQL does it much faster than the front-end modules.

I was hoping I could write some queries using SQL in MS Visual Studio which is connected to the Microsoft SQL Server and pull the reports faster (hours into seconds).

The problem is exporting the data once I write a query. Copy/Paste does work, but I am worried about corrupted data/missing information with doing that process (I hate copy/paste).

[Kyle123]

Just use msquery

[Norie]

Sorry, that doesn't really make sense.

The data is not 'in' Visual Studio, in fact it sounds like the use of Visual Studio is as some sort of middleman, and that might be what's slowing things down.