I have used dreamweaver to do a lot of php "programming" but now I need to
write a real php function.
I have a hosted mysql database that I need to export to MS Access. I can't
use myODBC to do it because hosting company denies access to db port. I
looked at other ways to dump the data but the escaped characters always
threw the import off. There probably a way to do using MySQLDUMP command.
HOwever, I remember a long time ago I wrote some code to read raw data into
lotus notes and figured there is probably a way to write out the data using
whatever field & record terminators I choose.
Keeping in mind the end goal is to write on e that is friendly to import
into MS Access, does anyone have an idea of how to use PHP to write a mysql
db out to a *.txt file formatted for easy import to MS Access?
If not, does anyone know how to write a mysql db out to a file?
Many thanks!