Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
boilerdam
Starting Member
2 Posts |
 Posted - 2013-03-04 : 13:52:33
|
| Hi, to start off, I'm a complete SQL novice. We just shifted the data logs for 2 of our manufacturing machines from an Access database to SQL. I now have to somehow retrieve the data from this new SQL database residing on a SQL 2005 server into Excel or some other version so that our Quality department can get their beloved production/defect numbers. We are running Win XP & Excel 2000. So far, I've tried the SQL Drill plug-in (but I think that only works for Excel 2005 onwards)and a number of other SQL software but I couldn't find anything useful or helpful. On my computer, I have created an ODBC connection with the appropriate server and it connects fine. We are looking for, for example, a table in Excel with various columns of data and appropriate column headers and then use PivotTable to play with 'em. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
|
|
boilerdam
Starting Member
2 Posts |
Posted - 2013-03-18 : 17:07:23
|
| Thanks James. I did read the link and I think options 1 & 5 and maybe option 4 would be useful to me. However, where do I type in those commands? Also, I'm going to try to use the DTS wizard; from the description it seems quite simple... But would it work if the database resides on a server and we access it from our desk PCs (clients)? |
 |
|
|
|
|
|
SQL N00b. Need help!