Using ODBC to link MS Access and Open Officeīefore you can opt for creating an ODBC data source for using MS Access database on Open Office, you first need to link these two applications. MS Access provides you support for ODBC, meaning to use an Access database with Open Office, you will have to create an ODBC data source. Open Office allows users to access multiple types of databases, provided they have support for standard interface specifications like the ODBC or the JDBC. ![]() The answer to this question is very simple. Imagine a situation where an user operating on Linux machine, using Open Office needs to Access MS Access files. In such a situation, not everyone will be operating on Windows and using only MS applications. ![]() There can be situations when people working in a single organization are making use of different operating software. In this article, we look at how we can use an Access database in MS Office and the steps involved in it like creating an ODBC data source.
0 Comments
Leave a Reply. |