- Approaches:
- Access exports its own tables: write access table data in a text file then use load data command from mysql to load those data in a table. Example: select access table->right click->export. From MySQL: run the queryLOAD DATA LOCAL INFILE ‘c:student.txt’ INTO TABLE student FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘rn’;
Syntax:LOAD DATA INFILE SyntaxLOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [FIELDS [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...]
- You can also use mysqlimporti command. Such as: Check the syntax here
- For converting you can also use: Converters That Generate Intermediate Files : Some converters can create sql files based on your access database. Then use MySQL tools to convert: mysql -h some_host -p -u some_user mydb < file.sql
- Converters That Perform Direct Data Transfer:Use Access to MySQL Tool
- Access exports its own tables: write access table data in a text file then use load data command from mysql to load those data in a table. Example: select access table->right click->export. From MySQL: run the queryLOAD DATA LOCAL INFILE ‘c:student.txt’ INTO TABLE student FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘rn’;
- A Great Resource
From: http://sitestree.com/?p=5130
Categories:90
Tags:
Post Data:2011-01-29 22:20:26
Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada
