Export from SQL Table to Worksheet Tabs

**akhlaq768** · 10-27-2009, 08:26 AM

Just wondering if this is possible,

I have a table in SQl that I want to export into Excel, which is pretty straight forward. Instead of transporting to a single worksheet tab in Excel, I want the data to be split based on a specific column into different worksheet tabs

For Example,

SELECT * FROM MyTable

Student Course Amount
2549 Art 100
3254 Science 300
3285 Art 234
2317 Art 674

So when I’ve exported the data to Excel, There should be 2 tabs labelled Art, Science, with the appropriate data in them

Can this be done?

**romperstomper** · 10-27-2009, 08:32 AM

The simplest way would be to use Excel's external data feature and set up an extract on each sheet returning the values you want. Which version of Excel are you using?

**akhlaq768** · 10-27-2009, 09:04 AM

i'm using Excel 2002

**romperstomper** · 10-27-2009, 09:08 AM

It's on the Data menu then - something like Data-Import external data-new database query, then just step through the wizard (it's fairly self-explanatory, I think) to connect to your database and get the fields you want, and apply the relevant filter for each sheet.

**akhlaq768** · 10-27-2009, 09:48 AM

i've followed your instructions and it export the data from SQL table to Excel, but how to i export to individual worksheet tabs based on the a specific column?

thanks