PEAR and Access DB Adivce

[shamiltonSCX]

I need to pull data from an access database and I hear pear is the way to go. Has anybody successfully used an Access DB on PowWeb's servers? Any advice?

[Neat Pete]

I didn't know anything about PEAR and still don't.

I downloaded my Access database on my PC into a file which contained SQL INSERTS inside PHP statements, one for each row. You have to write your own module code to do this.

I uploaded this file to PowWeb and then loaded the data straight into MySQL, using a PHP script.

Worked like a charm, file size about 900 K, approx 1500 rows of data sent to PowWeb. Each row was coded as a PHP string, the string contained the SQL INSERT statement, and the next line was a PHP statement to execute the "query" from the previous line.