Der findes flere programmer på nettet til at convert fra ACCESS>MySQL
En normal mysql dump-file vil se noglelunde ud som dette (1 Tabel med 3 felter '1tal,tekst,1tal')
#
# Struktur dump for tabellen `xcategory`
#
CREATE TABLE xcategory (
id int(255) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
parent_id int(255) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='Category Table';
#
# Data dump for tabellen `xcategory`
#
INSERT INTO xcategory VALUES (1, 'Computers & Internet', 0);
INSERT INTO xcategory VALUES (2, 'News & Media', 0);
INSERT INTO xcategory VALUES (3, 'Entertainment', 0);
INSERT INTO xcategory VALUES (4, 'Health', 0);
INSERT INTO xcategory VALUES (5, 'Government', 0);
INSERT INTO xcategory VALUES (6, 'Security', 0);
INSERT INTO xcategory VALUES (7, 'Science', 0);
INSERT INTO xcategory VALUES (8, 'Reference', 0);
INSERT INTO xcategory VALUES (9, 'Programming', 1);
INSERT INTO xcategory VALUES (10, 'Perl', 9);
INSERT INTO xcategory VALUES (11, 'Software', 1);
INSERT INTO xcategory VALUES (12, 'Movies', 3);
INSERT INTO xcategory VALUES (13, 'Music', 3);
INSERT INTO xcategory VALUES (14, 'Military', 5);
INSERT INTO xcategory VALUES (15, 'Tutorials', 1);
INSERT INTO xcategory VALUES (16, 'Linux', 1);
# --------------------------------------------------------
Til dit udpluk vil den se ud som denne
#
# Struktur dump for tabellen `kartotek`
#
CREATE TABLE kartotek (
id int(255) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='Kartotek Table';
#
mvh
rfh
# Data dump for tabellen `kartotek`
#
INSERT INTO kartotek VALUES (1000, 'København K');
INSERT INTO kartotek VALUES (1001, 'København K');
INSERT INTO kartotek VALUES (1002, 'København K');
INSERT INTO kartotek VALUES (1003, 'København K');
INSERT INTO kartotek VALUES (1004, 'København K');
INSERT INTO kartotek VALUES (1005, 'København K');
# --------------------------------------------------------