Re: Migration Utility - Free and easy alternative
You can export tables from Access through the ODBC connection to a MySQL database.
Right click table name
Select Export
Change type to ODBC
Type name to export to
Click ok
Select machine data sources
Pick your database to export too (had to of setup an ODBC connection first)
Click ok
That is it. I have tested this with 2 tables and it works fine. It doesnt create indexes or anything so you have to do that manually. But it does the general table build and population of data.
Subject
Views
Written By
Posted
3798
November 16, 2004 02:37PM
2169
November 29, 2004 12:57PM
2116
November 30, 2004 11:15AM
2131
December 31, 2004 09:51AM
2201
February 04, 2005 12:10AM
2095
December 01, 2004 10:30AM
2123
December 07, 2004 09:50PM
2042
December 10, 2004 05:11PM
2052
December 11, 2004 12:49AM
2311
December 13, 2004 02:17PM
2084
December 15, 2004 04:01PM
2204
December 15, 2004 05:17PM
2180
December 15, 2004 08:19PM
2223
December 16, 2004 04:25AM
2053
December 17, 2004 07:43PM
2034
December 28, 2004 11:26AM
2026
January 02, 2005 05:41PM
2016
January 03, 2005 02:51AM
2094
January 27, 2005 03:47AM
2103
February 01, 2005 12:59AM
2496
February 01, 2005 11:35AM
1801
February 03, 2005 12:43AM
2097
February 03, 2005 01:29PM
2228
February 06, 2005 01:21PM
2075
February 14, 2005 10:13AM
Re: Migration Utility - Free and easy alternative
2204
February 14, 2005 03:31PM
2327
March 07, 2005 03:16PM
2249
March 08, 2005 09:47AM
2300
March 08, 2005 11:21AM
2120
March 10, 2005 09:27AM
2184
March 10, 2005 11:42AM
3044
March 10, 2005 03:10PM
2522
March 11, 2005 11:43AM
2160
February 18, 2005 08:42AM
2050
February 24, 2005 06:53AM
2143
March 01, 2005 02:15PM
2064
March 02, 2005 11:37AM
1949
February 26, 2005 01:51PM
2085
March 02, 2005 08:34AM
2197
March 17, 2005 09:32AM
2024
March 20, 2005 10:59PM
2094
March 29, 2005 12:31PM
2327
April 01, 2005 10:58AM
2100
April 01, 2005 01:09PM
2086
June 07, 2005 10:37AM
2158
June 07, 2005 03:51PM
2059
July 18, 2005 09:46AM