Best way to capture/export about 45 fields - 3000 records

I am new to SQL server 2005 and trying to help a charity org move selected kids data out of a POS SQL POS database.

There are maybe 65 tables (only 5 - 7 tables will apply that will contain the 45 fields that I need). About 3000 records need to filtered to create a new database.

Ideally, with the small amout of data I actually need, we thought it would be best to just pump t into Excel so that I can pass the data to the charity where they can scrub the data themselves. We would then pump it into an online app that likes Excel imports.

After restoring the data sucessfully from a .bak file I am now failing miserably at converting a few tables with data into Excel even though it appeared to be straightforward. HELP please?

Can some experienced folks maybe help me out with a good plan?

Quote:

Originally Posted by computerchick

I am new to SQL server 2005 and trying to help a charity org move selected kids data out of a POS SQL POS database.

There are maybe 65 tables (only 5 - 7 tables will apply that will contain the 45 fields that I need). About 3000 records need to filtered to create a new database.

Ideally, with the small amout of data I actually need, we thought it would be best to just pump t into Excel so that I can pass the data to the charity where they can scrub the data themselves. We would then pump it into an online app that likes Excel imports.

After restoring the data sucessfully from a .bak file I am now failing miserably at converting a few tables with data into Excel even though it appeared to be straightforward. HELP please?

Can some experienced folks maybe help me out with a good plan?

There are a number of ways.

One is (if you need it only once) to query the tables in Query Analyzer (to a grid), then copy/paste into Excel. (You will lose the header row, though.)

Another one is to use an ODBC connection to the SQL database from Excel and retrieve the data from an "External data source".

The third one is that you use MS Access, pull the data into it (either from the source, or through ODBC), then export the tables into Excel.

If you need it regularly I suggest the second one; we have been using it widely.|||You can try the IMPORT/EXPORT Wizard which is quite easy to use.

Aash.|||Thank you for mucho for responding - it is much appreciated. What happened was that some of the tables were in am "incompatible format". I did end up getting it ported to Excel 2007 which in turn worked like a charm porting it into all other data formats as well. Yea! A process that works! :)

Quote:

Originally Posted by azimmer

There are a number of ways.

One is (if you need it only once) to query the tables in Query Analyzer (to a grid), then copy/paste into Excel. (You will lose the header row, though.)

Another one is to use an ODBC connection to the SQL database from Excel and retrieve the data from an "External data source".

The third one is that you use MS Access, pull the data into it (either from the source, or through ODBC), then export the tables into Excel.

If you need it regularly I suggest the second one; we have been using it widely.

|||Thank you too - that is what I was using but it would not work on the specific formatting applied to a few of my tables (the first time I had a corrupt bak file - woe is me! I did get it resolved after a bit of head banging!

Quote:

Originally Posted by patelaashish

You can try the IMPORT/EXPORT Wizard which is quite easy to use.

Aash.