Title: Accessing an MSAccess database using php
Last modified: April 22, 2023

---

# Accessing an MSAccess database using php

 *  Resolved [mikej999](https://wordpress.org/support/users/mikej999/)
 * (@mikej999)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/)
 * I would like to upload an MSAccess database (.accdb) to my Bluehost website and
   access the data using php in order to display it in the web pages. Read only,
   not write. Can I connect directly to the file from php, or do I have to convert
   the data first?
 * I have ploughed through documentation and tried things without success. The documentation
   seems to say that I have to convert the data into an ODBC database, but no matter
   which set of instructions I try to follow I get nowhere. It would be much easier
   to just upload the MSAccess file and access it directly, if that is possible.

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16678544)
 * Please explain how this ties to WordPress. Thanks.
 * For what it’s worth, if you’re doing this with WP, figure out how to export your
   data from access in a way you can import in into MySQL. Then, you can use the
   database tools built into WP to access the table(s) you create via access.
 *  Thread Starter [mikej999](https://wordpress.org/support/users/mikej999/)
 * (@mikej999)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16678606)
 * Bluehost operates via WordPress, ie, a Bluehost website is a WordPress website(
   I get emails from WordPress notifying me of software updates). The WordPress 
   blurb for these forums says they are for self-hosted and “Self-hosted WordPress
   requires purchasing hosting with another provider, such as Bluehost, …”. So I
   think I am in the right place.
 * I have tried exporting from MSAccess into things like MySQL, but there seems 
   to be endless software to download, and no matter what I try I never get there.
   Some of the answers on these forums on related topics seem to suggest that direct
   connection to MSAccess is possible, and that would (should!) be so much easier.
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16678708)
 * I think your question has a lot more to do with PHP than with WordPress. It would
   probably be better to post in more PHP-centric place like StackExchange.
 *  Thread Starter [mikej999](https://wordpress.org/support/users/mikej999/)
 * (@mikej999)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16678758)
 * Thanks, I’ll try there.
 * You refer to “the database tools built into WP”. Are there any that I should 
   be aware of, other than php itself?
 *  Moderator [Yui](https://wordpress.org/support/users/fierevere/)
 * (@fierevere)
 * 永子
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16678777)
 * “alien” databases can be accessed with ODBC driver (its a PHP extension)
 * Some documentation can be found using search terms
   PHP ODBC UnixODBC MSAccess
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16679428)
 * see [https://developer.wordpress.org/reference/classes/wpdb/](https://developer.wordpress.org/reference/classes/wpdb/)
 *  Thread Starter [mikej999](https://wordpress.org/support/users/mikej999/)
 * (@mikej999)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16680291)
 * Many thanks for the replies. Hopefully I’ll get there, but it will take time 
   so I’ll close this topic as ‘resolved’.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Accessing an MSAccess database using php’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [php](https://wordpress.org/support/topic-tag/php/)

 * In: [Developing with WordPress](https://wordpress.org/support/forum/wp-advanced/)
 * 7 replies
 * 3 participants
 * Last reply from: [mikej999](https://wordpress.org/support/users/mikej999/)
 * Last activity: [3 years, 1 month ago](https://wordpress.org/support/topic/accessing-an-msaccess-database-using-php/#post-16680291)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics