Visit my web site and look at data converters Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)870 922 0247 Fax +44(0)1323 419554 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin & Luxembourg
-----Original Message----- From: McKeever Chris [mailto:[EMAIL PROTECTED] Sent: 04 December 2003 23:14 To: MySQL Lists; Warren Subject: Re: automate MSAccess into MySQL On Thu, 04 Dec 2003 15:00 , Warren <[EMAIL PROTECTED]> sent: >Is there a way to automate an export of a single table from a MS Access >DB into a Temp MySQL DB? > >I would like to make a front end that the client can select the correct >MS Access DB and then the correct table and once those are selected the >table will be exported into the MySQL DB for my C++ front end to utilize. > >Does anyone know how to do this? > >Thanks > >Warren I have read posts about implimentations of this. You can easily grab the table structure using VBA and then connect to MYSQL to create and import row by row (or even out to a CSV with a text file for the table schema). PHP could do the same, but I do not know if you can get the table structure as easiliy. I guess the main question is, do you want to keep field types, or just quickly push the data over. ------------------------------------------- Chris McKeever If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com http://www.prupref.com ---- Prudential Preferred Properties www.prupref.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]