We use Simply Accounting at our company. Lots of the information we need to manage day to day operations is already in the Simply Accounting data files. Such as prices. Is there a way I can retrieve that information from Simply Accounting an use it in Ms-Access.

In other words is there a way I can link Simply Accounting tables to my Ms-Access application?

Thanks.


[LGuzman]

__________________
[LGuzman]

I have a question, what DBMS (Database Management System ex. MySQL, Access, MS SQL, Oracle, Sybase) is Simply Accounting or is this a database?

When you say data files are those text files? meaning is the file extension .txt

Because if this is a DBMS you can link to your Access by ODBC (object database connection).

First let me thank you for having taken the time to answer me.
Second, I apologize for not having answered your post earlier.

I have been looking into your suggestion but I keep running into walls... The data files are of extension .SDB. I have tried researching what creates these files but have found no valuable information. I do think it must be a database management system but don't know which and what drivers to use in ODBC. (Which is another challenge for me since I have never used it).

Once again: thanks.



[LGuzman]

Luis,
Talk to your IT administrator and ask how you can have a link via ODBC connection from this main-frame server to your microsoft access database. That way you can retrieve data thru MS Access application.

John

Thanks for your suggestion John.

However I would like to point out that these files (.sdb) are not on a main-frame but reside locally on the same PC where I have my Ms-Access application.



[LGuzman]