Hi Everyone,
I'm running Version 18.1.0.12, Windows 7 32-bit and Office 2010.
I was wondering if anyone had used Microsoft Access (2010 or 2013) to link to Sage via ODBC ? I can successfully export data to Excel but I'm not sure if Access will work as well.
I've tried using Open Office Apache to open the Sage tables via ODBC but get a "Syntax error in SQL expression". I'd prefer to find out if I'll get a similar error in Access before I buy the software.
Many thanks.
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
Microsoft Access, ODBC and Sage.
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Microsoft Access, ODBC and Sage.
Access works fine... but... you need to make a dsn.
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.
Re: Microsoft Access, ODBC and Sage.
Thank you for your reply. I've been using the SageLine50v 18 driver with Excel so I'll give it a go.
Regards.
Regards.
Who is online
Users browsing this forum: No registered users and 1 guest