Databases :: MySql :: Importing structure from MS_Access Databse to MY Sql Database |
|||
By: VB guy  |
Date: 02/11/2004 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
I am having table structure with huge data and I want to import this table to My sql databse table to utilize it for my application.Is It Possible? How To access the MS_access Database from My sql? |
|||
| By: VGR | Date: 03/11/2004 05:32:00 | |
Type : Answer |
| 1a) find a way to include "column headers" on the first row of your exported data or 1b) (better control) re-create manually the TABLE in MySql then 2) export from Access as format CSV finally 3) import data in Mysql after copying the .csv file to its server : LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; |
|||
| By: carchitect | Date: 03/11/2004 22:48:00 | |
Type : Comment |
| well very simple just search in google for converting access to mysql there are lots of tuilites are available |
|||
| By: carchitect | Date: 03/11/2004 22:48:00 | |
Type : Comment |
| it will give you .sql file |
|||
| By: mquiroz | Date: 03/11/2004 23:21:00 | |
Type : Assist |
| Hi Jayasree! It's even easier that that, you just need to install MyODBC 3.5x ODBC drivers (check mysql homepage) and make a DSN (control panel, odbc, blah, blah) then you open your access database on microsoft acces, then select with the right mouse button, click on "save/export", and then instead of selecting a filename go to the end of the list and select "ODBC", then select your previously created DSN and voilá: you have your access table on mysql!!! |
|||
| By: Squibi | Date: 04/11/2004 22:57:00 | |
Type : Comment |
| There is a simple app do this work. Check http://www.mysql.com, downloads section |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
