Is it possible to write a data query in excel / ms query to connect to sage 50 v19? I can see that there is an ODBC driver available when in excel, but it doesn't connect to the data and I also am unable to create a new user dsn as the odbc driver is not available. We have to update 60 companies manually each month and it is very time consuming. A macro or some form of automation would be very helpful.
Thanks
Greg
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
- - - - - - - - - - - - - - - - - - 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
Creating an ODBC data query in macro
-
foodiefinance
- User
- Posts: 1
- Joined: 15 Nov 2013, 10:35
- Sage Version: v2013 19 UK/Europe/Africa
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Creating an ODBC data query in macro
It can be done with a VBA macro
You may have several issues, as regardless of anything else, you should be able to connect to data, the drivers should be there and you should be able to connect.
You need a 32bit version of Office, the latest version doesn't work with some of the older versions of Sage.
You need to look for/configure the 32bit ODBC drivers not the 64 bit drivers.
You may have several issues, as regardless of anything else, you should be able to connect to data, the drivers should be there and you should be able to connect.
You need a 32bit version of Office, the latest version doesn't work with some of the older versions of Sage.
You need to look for/configure the 32bit ODBC drivers not the 64 bit drivers.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 1 guest