Re: automate MSAccess into MySQL
Warren wrote: 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 There are a number of apps and plugins to Access and scripts that do this. Have a look on the MySQL website, under 'contributed' or something like that. Be aware, however, that some of them make 'interesting' decisions about what column types to use. Carefully review their source before using them yourself; even more so if your customers will be the ones using the app. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
RE: automate MSAccess into MySQL
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]