将SQL查询从MYSQL导入到MsAccess

Question

我需要创建sql语句来将数据从现有的MySQL数据库导入到MsAccess中。有人对我能做的最好的方法有什么想法吗？

这是我用来在MySQL中创建数据库的代码，仅仅是为了给出表的概念等等。

 CREATE DATABASE IF NOT EXISTS horsedb;
 USE horsedb; CREATE TABLE `horse`.`horse` (
`HORSE_id` INT NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(45) NULL,
`Colour` VARCHAR(45) NULL,
`Sire` INT NULL,
`Dam` INT NULL,
`Born` YEAR NULL,
`Trainer_id` INT NOT NULL, 
PRIMARY KEY (`HORSE_id`))
ENGINE = InnoDB;

USE horsedb; CREATE TABLE `horse`.`showsite` (  
`show_id` INT NOT NULL AUTO INCREMENT,  
`Name` VARCHAR(45) NULL,
`Address` VARCHAR(45) NULL,
PRIMARY KEY (`show_id`));

USE horsedb; CREATE TABLE `horse`.`judge` (  
`Judge_id` INT NOT NULL AUTO INCREMENT,  
`Name` VARCHAR(45) NULL,  
`Address` VARCHAR(45) NULL, 
PRIMARY KEY (`Judge_id`));

USE horsedb; CREATE TABLE `horse`.`event` (
`Event_id` INT NOT NULL AUTO INCREMENT,
`Show_id` INT NOT NULL, 
`Event_name` VARCHAR(45) NOT NULL,
`Judge_id` INT NOT NULL,
PRIMARY KEY (`Event_id`),
INDEX `show_id_idx` (`Show_id` ASC),
INDEX `judge_id_idx` (`Judge_id` ASC),
CONSTRAINT `show_id`
FOREIGN KEY (`Show_id`)  
REFERENCES `horsedb`.`showsite` (`Show_id`)  
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `judge_id`    
FOREIGN KEY (`Judge_id`)    
REFERENCES `horsedb`.`judge` (`Judge_id`)  
ON DELETE NO ACTION
ON UPDATE NO ACTION);

USE horsedb; CREATE TABLE `horse`.`entry` (
`Event_id` INT NOT NULL AUTO INCREMENT, 
`horse-id` INT NOT NULL, 
`Place` INT NULL, 
INDEX `horse_id_idx` (`Horse_id` ASC),
CONSTRAINT `horse_id`    
FOREIGN KEY (`Horse_id`)
REFERENCES `horsedb`.`horse` (`Horse_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION);

USE horsedb; CREATE TABLE `horse`.`prize` ( 
`Event_id` INT NOT NULL AUTO INCREMENT, 
`place` INT NULL,  
`money` INT NULL, 
 ));

USE horsedb; CREATE TABLE `horse`.`trainer` (  
`Trainer_id` INT NOT NULL AUTO INCREMENT,  
`Name` VARCHAR(45) NULL, 
PRIMARY KEY (`Trainer_id`));

Answer 1

将MySQL表转换为Access的最直接方法是安装MySQL ODBC驱动程序(MySQL连接器/ODBC)，然后使用ODBC从MySQL导入(而不是链接)表。关于更详细的说明，见：

在Microsoft中使用Connector/ODBC