WordPress Microsoft Access Hack?

  • I would like to prebuild a lot of stuff coming from Microsoft Access and drop it into WordPress (there are plenty of programs that let you dump access to mysql). I was curious if anybody has already built a WordPress database for Access with the table types in correct format and relationships determined?
    I might try to hack it myself but it seems like I could save a lot of time if somebody has already done this.
    Thanks.

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

  • Not that I know of.
    What is this for anyway? Just for local computer? It’s so easy to install mysql to your computer.

    Thread Starter americasroof

    (@americasroof)

    I specifically would like to use the blog for discussions and information about specific mountains. The lists (involving thousands of names) are in excel format. It would be easier for me to tweak the data in an Access RELATIONAL database and then use a program such as AccessDump to generate the .sql to insert the data into my WordPress mysql FLAT file. WordPress offers an excellent format for handling this.
    I surely can’t be the first person to think of doing this. That’s why I was wondering if somebody had already done it. Even if you do convert mysql to Access via a local install it still does not show how the tables are related and in what manner (e.g., one to many, etc.).

    You probably are the first to use WordPress for such purpose.

    Is there some hack for MS Access. I would like to install a WordPress on a server, that only has MS Access and the admin doesn?′t want to install MySQL ??

    And Access is a relational db ? ??
    @vido : Move to a proper host.

    Word of warning Vido: Access is an extremely poor choice for running any sort of concurrent access system i.e. a web page where you will have more than one reader at any given time.

    Because of the atrocious way it handles locks and concurrency, you are likely to see abysmal performance. Access is not very scaleable. It’s fine for a few users but it quickly bottlenecks which is why nobody builds online systems based on Access.

    americasroof, why don’t you export the excel file as csv and import that (via PHPMyAdmin or such like)?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WordPress Microsoft Access Hack?’ is closed to new replies.