Our branch in Canada is using Simply Accounting Pro 2010
I have been extracting data from SA with Excel
They have now opened a created a new company in SA for 2010
How can I get the ODBC link to point to the new .SAI file?
THIS post should give you a clue.
When you connect using the ODBC, just supply the correct Server/Port pair and any credential (user name/password) that may have changed.