Exporting data from MS Access to MySQL

Dev Shed Forums Sponsor:

August 2nd, 2004, 07:56 AM

m.inckle

Contributing User

Join Date: Feb 2004

Posts: 47

Time spent in forums: 1 h 35 m 11 sec
Reputation Power: 10

Exporting data from MS Access to MySQL

Hi

im trying to automatically transfer some data from a Ms Access Db to a MySQL.

I connect to them both using ODBC and i know the query i want to get the correct data, but where do i go from there.

i want to get field1, field2, field3 in table1 in MS Access to field4, field5, field6 in table2 in MySQL

Does anyone have any tips for me???

August 3rd, 2004, 12:39 AM

Scorpions4ever

Banned ;)

Dev Shed God 9th Plane (9000 - 9499 posts)

Join Date: Nov 2001

Location: Woodland Hills, Los Angeles County, California, USA

Posts: 9,390

Time spent in forums: 1 Month 4 Weeks 1 Day 22 h 32 m 40 sec
Reputation Power: 4080

Have you tried using the TBatchMove component under the BDE tab?

__________________
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne

Viewing: Dev Shed Forums > Programming Languages - More > Delphi Programming > Exporting data from MS Access to MySQL

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump