hello everyone how can i import Ms Access data into MySql thank you
10 5153 mwasif 802
Recognized Expert Contributor
I have the distinctive feeling that the MySQL migration kit for Access is not free of charge (but I could be wrong).
Another solution would be to do it yourself.
Write a server application (like PHP) that reads the tables and data from the Access database and stores it into the MySQL database.
Using a (free) tool like Adodb makes it relatively easy to do.
Holler when you need more info.
Ronald
hello everyone how can i import Ms Access data into MySql thank you
First export the tables from MS-Access into a text file and then use infile command to import that text file into MySQL.
Here is an example of infile command:
LOAD DATA INFILE ‘name_of_export ed_file.txt’
INTO TABLE table_name
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\r\n’;
thank for all yr help guy really appreciate
thank for all yr help guy really appreciate
That why we are here (one of our goals in life).
Do you want to tell us what solution you g=have chosen?
Ronald
Hi,
how about copying the tables contents directly by INSERT INTO SELECT FROM..., without having to export/import them and so on?
Of course first you've got to create the tables in mySQL with phpMyAdmin or another mySQL tool. Then all you need is a Window$-PC with Access and the mySQL ODBC driver. Open the Access database and create a new table - but make it a linked table, using the OBDC entry of your mySQL database as source. Select the appropriate mySQL table. Then copy the data from within Acce$$ by using SQL: - INSERT INTO
-
mysql_connected_table1
-
SELECT
-
*
-
FROM
-
access_old_table ;
Regards,
Bernd
Like MySQL, the MS Access db must have meta data about the tables you want to copy. So read the Access table's metadata, construct a MySQL CREATE TABLE command with that information and issue it.
Then copy (INSERT as in the previous post) and you're done.
Ronald
I have the distinctive feeling that the MySQL migration kit for Access is not free of charge (but I could be wrong).
...
Ronald
Actually, you are :P. Mysql Migration tools are released under the GPL and under commercial license by mysql for any OS.
More info: http://dev.mysql.com/downloads/gui-tools/5.0.html
Hope it helps,
Pedro.
Actually, you are :P. Mysql Migration tools are released under the GPL and under commercial license by mysql for any OS.
More info: http://dev.mysql.com/downloads/gui-tools/5.0.html
Hope it helps,
Pedro.
Pedro, you are absolutely right about this. So it was entirely my mistake. Soory foir that.
Ronald
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Bruce A. Julseth |
last post by:
Newbie Question:
Is there a way to import MS Access into MySQL? Maybe create a CSV or
something. If so, what would be the SQL to do this?
Thanks...
Bruce
|
by: NotGiven |
last post by:
I have a db that I need to dump into a format that can be easily read my MS
Access. I tried the dump with regular PHPAdmin. Then I used the dump to
run a query in MS Access.
Errors occurred because MySQL inserts a backslash, "\", in front of an
apostophe that user enters in a text field and MS Access doesn't know how to
interpret that.
Any ideas for easily getting whatever kind of data from MySQL to MS Access?
|
by: jj |
last post by:
It's taking forever to upload 400,000 records to the database through
access/odbc, and I've tried phpMyAdmin's interface but it seems to timeout
during import of a CSV file. Is there a better way to import 400,000+
records?
|
by: Johnny |
last post by:
I was looking for information on how to import an excel file or other
text file into a MySql database. I have done this with both access
and SQL Server and am looking for a way to do this in MySql. I have
several hundred items i want to import into a parts database that is
currently in an excel file but can be saved as comma separated or
other format. Any help would be greatly appreciated. Thanks in
advance.
Zach
|
by: Kajol |
last post by:
Hi All,
can u plz tell me how to import data from mysql to another database.
& how to export data from anotherdata base to mysql
Thanx for ur Advice
Regards
Kajol
| |
by: klowe |
last post by:
Hi, I'm an Access newbie and need to update an Access database from a
web application. I'll need to add new records and also update existing
ones.
What I was thinking of doing is have my web app create a text file with
Access SQL INSERT/UPDATE statements and get Access to import and
execute this file.
Is this possible?
|
by: nepifanio |
last post by:
Hi Guys,
I'm trying to import data out of MySQL db to MS Access 2003 using
ImportXML. I don't have any problems doing the import, except for one
table with a "text" field defined. I'm getting an error message saying
"The field is too small to accept the amount of data you attempted to
add. Try inserting or pasting less data.".
Thanks,
|
by: phillip.s.powell |
last post by:
We're looking at a GUI interface for our MySQL DB and I am interested
in MySQL Administrator, however, one of our requirements is to be able
to import/export databases. Is this possible or do I need to know else
(e.g. Navicat)?
Thanks
Phil
|
by: NewbieSupreme |
last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x,
which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a
table to a text file, tab-delimited, text qualifyer of "none" (this is how I
read to do it from newsgroups).
When I use the Query window in phpmyadmin to import the text file, it waits
a while, then returns an error:
#1064 - You have an error in your SQL syntax; check the manual that...
|
by: Randy |
last post by:
Folks:
We have a web-based app that's _really_ slowing down because multiple
clients are writing their own private data into a single, central
database. I guess the previous programmer did things this way because it
made things easy. Well, I'm the person that has to put up with
the long-term headache.
Anywho, someone at work wants things sped up, so what I'm looking
at doing is this for each client:
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |