Hi,
you have to create an exportfile with ACCESS separated with colons for
example.
Then import this textfile in your mysql-database.
It looks like this:
LOAD DATA LOCAL INFILE "C:\\name_of_your_file.txt"
INTO TABLE name_of_your_table
FIELDS TERMINATED BY 'your_separator for example ,'
ENCLOSED
en ON
tbl_autor.autorenID=tbl_zuordnung_autoren_medien.autorenID) ON
tbl_medien.medienID=tbl_zuordnung_autoren_medien.medienID
WHERE (((tbl_medien.medientypID)='$medium'))
Thanks,
Patrick
Patrick Schäfer
magna moliri
Projektmanagementgesellschaft mbH & Co.KG
Hanauer Landstraße 184
6031
