News for hackers. Stuff that matters.

Any PHP class to convert MS access tables to MySQL?

Hi.. I am working on a web project which lets users upload ms access files, and data should be submitted to MySQL DB, and then displayed to the user in a control panel.

I can't find any PHP class that would help me do that.. or even a point where I can start from.

Any thoughts or help about that? Thanks so much in advance, Ahmed.

( 4 comments | on HN )
Re:Any PHP class to convert MS access tables to MySQL? by modulow on Friday April 29, 2011 @08:05AM (#2497071)
That's not really what Hacker News is for...why don't you go to http://stackoverflow.com and ask there?
Re:Any PHP class to convert MS access tables to MySQL? by jrsmith1279 on Friday April 29, 2011 @08:44AM (#2497139)
If you're not going to help then why even post? When someone comes across this post in their searches it's not going to help them at all and it's a waste of time. Your post is similar to people posting "Use the search function" in forums, which is also a huge waste of time.
Re:Any PHP class to convert MS access tables to MySQL? by AlexC04 on Friday April 29, 2011 @09:00AM (#2497177)
Honestly, I thought the same thing. (Why doesn't he go to stack overflow and ask?) then I thought.

"Oh. My. God. What if he's never even heard of StackOverflow?"

So actually, the above comment isn't inappropriate in the least. A new thread in Hacker News honestly isn't the right place to ask for help with programming connectivity to Microsoft Access (Hint: use ODBC).

But stack overflow is.

Quite often, the "use search" is a rude response ... more often, for example in the case of Hacker News it's also about as useful as a humorous yet slightly rude colloquial comparison between two disparate entities. (eg: tits on a bull).

Anyways.

He is right. HN isn't SXCH. His comment was worded politely and may prove useful to the original poster.

Re:Any PHP class to convert MS access tables to MySQL? by jrsmith1279 on Friday April 29, 2011 @08:40AM (#2497128)
Is it possible that these users could export the MS Access files to CSV? Importing CSV in to MySQL using PHP is pretty easy, but I'm not coming up with anything for doing it with MS Access files.