Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Search found 4 matches

by beancounter67
12 Jul 2011, 20:23
Forum: Sage 50 UK version General Help
Topic: Project Module - extracting data into Excel
Replies: 6
Views: 6240

Re: Project Module - extracting data into Excel

This is really strange. If I load MS Query, I can see the SageLine50v16 driver (but I get an SQLSetConnectAttr error when I try to open the database), but when I look in ODBC Administration Tools it's not there.

Any ideas?

Sara
by beancounter67
12 Jul 2011, 10:09
Forum: Sage 50 UK version General Help
Topic: Project Module - extracting data into Excel
Replies: 6
Views: 6240

Re: Project Module - extracting data into Excel

I've looked in the ODBC Administration Tools and can't see the Sage driver - the only one I get the option to add is a SQL Server.

I can definately run reports in Sage, including ones I've amended.

I'm using Sage 50 2010 V16 on Windows 7 - could this combination be the problem?

Sara
by beancounter67
12 Jul 2011, 08:21
Forum: Sage 50 UK version General Help
Topic: Project Module - extracting data into Excel
Replies: 6
Views: 6240

Re: Project Module - extracting data into Excel

Thanks for the info. The problem I have is that I can't find the Sage 50 ODBC driver - it should be in %drive%/windows/system 32 but it's not. I've tried using the ODBC set up routine in %drive%/sage/accounts/ODBC32 but other than telling me the software is installed (Sage Accounts ODBC) I get no ...
by beancounter67
11 Jul 2011, 18:16
Forum: Sage 50 UK version General Help
Topic: Project Module - extracting data into Excel
Replies: 6
Views: 6240

Project Module - extracting data into Excel

I need to pull some project data out of Sage 50 v16 to create a bespoke report in Excel. I've looked at the preset Sage extracts and also on the net at tools like WebXel but none of them have anything for the project module.

Can anyone help?

Sara