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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SQL N00b. Need help!

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

Posted - 2013-03-04 : 14:43:33
See if any of the methods (including DTS) on this page will help you: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
Go to Top of Page

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)?
Go to Top of Page
   

- Advertisement -