ASP forum question - help:)

Didn't know where to put this - I know nothing about asp so...
anyway - my question:

I have a client who wants to transfer all the data from an asp forum to a new - php forum. All the people he's asked so far told him it's not possible...either that or it's too much work.
He really wants to change the forum as it's kinda crappy and he needs better design. And he has too much data and he'd hate to loose it.

can this be done? how?]

I appreciate any help....

It's really not a question of ASP to PHP, it's about (Access, SQL Server) to MySQL (or whatever database, but probably MYSQL).

SQL to SQL database conversion is, I hear, pretty darn easy. I'd simply look on Google for a database conversion utility. It nothing else, export the data from Access to a flat file, then import that back into MySQL. Easy as pie. If you need some help getting the data out of the format that he's in now, let me know and depending on the database, I can probably do it for you and send you the file.

You are going to run into a problem with naming for one. You will probably have to do a bit of inspection with each table in both to get the data to match up.
I know this sounds goofy, but it might be easier to export the data to Access, then using myODBC (free download) import it into mySQL. But the difficult part might be matching tables, columns from one db to the next, if they arent the same.
You could import the data from Access to mySQL, then table by table run some sql code to query one table and update the other. Sounds painstakingly tedious.
Are you comfortable with SQL?

Thanks a lot guys - I think
I don't really understand what you told me but I will relay it to my client and he'll be able to tell his programmer that it [strong]can[/strong] be done...

anyway - thanks a lot again...