[UPHPU] MS Access
mydarb at comcast.net
Thu Dec 16 11:51:19 MST 2004
I once had to do a project using MS Access as the backend with PHP as the
scripting language. That's when I found and started to use ADODB
(http://adodb.sf.net) - the best part about it is the portability. Once you
write the script if you need to use it with another DMBS, just change one
line of code and you're ready to go.
If I understand correctly, you are looking to move the data to another
DMBS... What I would probably do is write a script that would create insert
statements that could just be copied and pasted into phpMyAdmin or whatever
you use to run SQL queries by hand.
> -----Original Message-----
> From: uphpu-bounces at uphpu.org
> [mailto:uphpu-bounces at uphpu.org] On Behalf Of Ashley Oviatt
> Sent: Thursday, December 16, 2004 11:12 AM
> To: uphpu at uphpu.org
> Subject: [UPHPU] MS Access
> Ok, I have an MS Access database. I need to get the info out
> of it so I
> can use it in a php script. The problem is that MS sucks at
> exporting to
> a csv file, or at least I can't get a clean csv dump from it.
> So what's the best way to get that data into a useable format?
> UPHPU mailing list
> UPHPU at uphpu.org
> IRC: #uphpu on irc.freenode.net
> Sponsored by hostinginferno.com!
More information about the UPHPU