Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > Access数据表转化成mysql数据表_MySQL

Access数据表转化成mysql数据表_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:41:26
Original
1044 people have browsed it

bitsCN.com
Access数据表转化成mysql数据表 在网上搜了搜如何转换，方法比较多。但我的方法貌似极其简便。在access中导出excel格式文件，在mysql中导入excel。mysql的可视化操作工具真简便！ 具体做法：   1、在access的表中选择，文件->导出->保存类型->excel->填写文件名2、Navicat for mysql的表中，导入向导->excel类型-》选中刚才的文件->下一步->。。。->对应目标栏位和源栏位->开始即可 前提是：两个表的字段数据类型一致。主键会比较麻烦，可以先转化后改动主键  作者 hss871838309 bitsCN.com

Related labels：
access mysql how data sheet
source：php.cn
Previous article：Centos下安装mysql命令_MySQL Next article：MySQL慢查询分析_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The problem that mysql service cannot be restarted after mysql upgrade
From 1970-01-01 08:00:00
0
0
0
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
php - In wamp, how to use mysql installed by myself instead of wamp integrated mysql?
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template