How familar your are with Access? VBA?
May be you can write something to create phPay import files.
Or complete SQL-Queries to import them with phpMyAdmin.
This would be a sure but not easy way. But such an export/convert script can help other user, if you release it and can be used in future for updates. So your Access-Database is like an offline tool.
Another way is to export informations into Excel. There you make the right format for phPay and exports from Excel into CSV file.
Maybe Access can export into CSV-File too?
Greetings,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for the reply. Access can indeed save things as CSV, though it can also communicate direct with MySQL if you've got the MySQL ODBC driver installed.
There's also, I've just discovered, a commercially available tool to convert various formats (including Access) to MySQL. I've just downloaded an evaluation copy from
I was more wondering about the table structure in phPay. My database is modelled on the MS Access sample database for Northwind Trading that ships with Access and they've designed their table structure rather differently to phPay.
I *think* I can work out what data I need to append to each column in phPay but I was just wondering if anyone had produced any documentation about it.
If they haven't I'll happily write something up for you when I get the time (assuming I manage to import my data successfully, that is!).
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've at last got phPay working with help from this forum.
Next question.
I've got an existing product database in Microsoft Access 2000 which contains about 7,000 products. What's the best way to import them into phPay?
Steve
How familar your are with Access? VBA?
May be you can write something to create phPay import files.
Or complete SQL-Queries to import them with phpMyAdmin.
This would be a sure but not easy way. But such an export/convert script can help other user, if you release it and can be used in future for updates. So your Access-Database is like an offline tool.
Another way is to export informations into Excel. There you make the right format for phPay and exports from Excel into CSV file.
Maybe Access can export into CSV-File too?
Greetings,
Andreas.
Dear Andreas
Thanks for the reply. Access can indeed save things as CSV, though it can also communicate direct with MySQL if you've got the MySQL ODBC driver installed.
There's also, I've just discovered, a commercially available tool to convert various formats (including Access) to MySQL. I've just downloaded an evaluation copy from
http://www.mysqlmaestro.com/
and will let you know how I get on.
I was more wondering about the table structure in phPay. My database is modelled on the MS Access sample database for Northwind Trading that ships with Access and they've designed their table structure rather differently to phPay.
I *think* I can work out what data I need to append to each column in phPay but I was just wondering if anyone had produced any documentation about it.
If they haven't I'll happily write something up for you when I get the time (assuming I manage to import my data successfully, that is!).
Steve