SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SQL N00b. Need help!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

boilerdam
Starting Member

USA
2 Posts

Posted - 03/04/2013 :  13:52:33  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3742 Posts

Posted - 03/04/2013 :  14:43:33  Show Profile  Reply with Quote
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

USA
2 Posts

Posted - 03/18/2013 :  17:07:23  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000