Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

is it possible to import datas from a mdb file (access) into a mysql from php?

Posted on 2016-08-17
3
Medium Priority
?
62 Views
Last Modified: 2016-08-17
Hello guys

I want to publish a mdb file into web folder and I'd like to import the datas from it.

is it possible? If so, could you give me a simple example or point a site where I could see how to do ?

Thanks
Alex
0
Comment
Question by:hidrau
3 Comments
 
LVL 111

Accepted Solution

by:
Ray Paseur earned 1000 total points
ID: 41759371
Short answer: Probably "yes, it's possible."

If you can export the mdb file in a predictable format, such as a CSV file, you can import the CSV into a MySQL database.  This can be done with PHP or perhaps with a tool like phpMyAdmin.
1
 
LVL 12

Assisted Solution

by:jet-black
jet-black earned 1000 total points
ID: 41759405
In addition to Ray Paseur's solution, you can also use third party tool like Access To MySQL to transfer your data.
1
 
LVL 1

Author Closing Comment

by:hidrau
ID: 41759418
thanks a lot
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question