SageForum for UK versions of Sage 50- Help and support.

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.

Access works fine... but... you need to make a dsn.

Thank you for your reply. I've been using the SageLine50v 18 driver with Excel so I'll give it a go.

Regards.