473,503 Members | 5,284 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Copying Data from Access to MySQL

1 New Member
i want the procedure to export .mdb file to sql file move file to server using ftp and import into mysql database using a batch file
Sep 20 '14 #1
3 1371
jimatqsi
1,271 Recognized Expert Top Contributor
ramunune,
You can export the data directly to the host of the mysql database very simply. Just make an ODBC connection from Access to the mysql db (that is, make table links in Access) and write queries to move the data. Depending on what version of Access you are using, there might even be an export wizard to help with that part.

You may, however, run into a lot of issues with individual fields. Is the mysql db designed to mirror the Access db? The devil is in the details and you haven't shared many details.

Good luck,

Jim
Sep 20 '14 #2
zmbd
5,501 Recognized Expert Moderator Expert
ramuneue:
The MySQL user manual is quite user friendly.
Please read chapter 6 and in particular 6.4 Using Connector/ODBC with Microsoft Access

Your only other option is to export the data to a csv file and then call for the file from MYSQL.

In anycase as J has pointed out there are data type issues that you should check for... a few of the MySQL types are not supported in MS Access.
Avoid the Boolean field if possible or make sure that they are all set, there can be issues with null values.
Sep 20 '14 #3
NeoPa
32,557 Recognized Expert Moderator MVP
Eminently deletable request for work.

As there is some useful info in the replies, however, I'll just close it.

Feel free to ask a proper question if you'd like some help.
Sep 21 '14 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1983
by: Charles Alexander | last post by:
Hello I'm trying to redisplay and reorganize some data off a huge Excel spreadsheet. I figured it would be easier to manipulate if I dumped the data into MySQL with the help of phpMyAdmin. ...
0
918
by: D | last post by:
I am developing a reuseable data access library for Access, MSSQL, MySQL, Oracle and etc, for some of other projects. Initially I build up classes for each database, and a client application is...
0
1008
by: dord | last post by:
I am developing a reuseable data access library for Access, MSSQL, MySQL, Oracle and etc, for some of other projects. Initially I build up classes for each database, and a client application is...
11
1589
by: sanders_mike_newsgroups | last post by:
Hi I have a web app that needs to be able to use either SQL Server or MS Access - depending upon the installation. I want to avoid having unnessesary amounts of code (eg: dim x as...
4
2254
by: riskhan | last post by:
Hi friends I am developing a PHP program with support of MySQL and Oracle. I like to copy table data from MySQL to Oracle. MySQL table contains more than 250000 records. When i starts running...
1
1598
by: laxgb | last post by:
Hi I tried to use following code to access MySQL database but the error 'Object reference not set to an instance of an object' was happened: Dim MyConString As String = "DRIVER={MySQL ODBC 3.51...
3
5209
by: Suresh P | last post by:
Hi All, I tried to access the mysql database in ODBC using ip address and username/password. It returns, "cannot connect to MySQL server on IP ADDRESS(10060)". This could be related to Firewall...
1
3063
by: Frank Moyles | last post by:
I have two simple function in PHP that I want to convert to C# - function Doit($enc_user_name, $enc_password) { $result = $mysqli->query("call sp_userAuth('$enc_user_name','$enc_password')"); ...
10
5134
by: milas57 | last post by:
hello everyone how can i import Ms Access data into MySql thank you
0
6490
by: neuraljay | last post by:
hi everyone. I am trying to build a jsp using webwork, hibernate and mysql. And right now I am doing its unit testing. Everytime I run the test I am getting this error: Error JDBC exception on...
0
7194
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7070
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7316
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5566
agi2029
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,...
1
4993
isladogs
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...
0
3160
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...
0
3148
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
729
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
372
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.