A question about Sage.

[hughjayteens]

I have a client who wants an Access database writing, but one feature he would like to be able to do is get information out of his Sage database - Can Access read Sage (or how does Sage save it's data)?

Cheers

C

[alunr]

You can read only from most tables by using the ODBC driver.

Get External Data > Goto Link Tables > Select ODBC Databases in the "Files of type dialog"

Hunt around for the Sage listing (mine was InstantAccountingV6 or something)

Leave username and password blank then you'll get a list of all the tables.

Hope that helps.

PS I'm write access stuff all the time so give me shout if you need any help.

>> Edited by alunr on Wednesday 23 July 17:18