Need help with importing data
I'm fairly new to MySQL and have been tasked with exporting data from an Access database to MySQL. Prior to this, I had made a test database, using a test .xml file, just to see how it worked. I managed to successfully import the data from the .xml file without much issue. I moved on to import data from the Access database (again using an .xml file), but I'm having an issue in which ALL the data is getting dumped under the first field. I took a look at the .xml file, and I noticed the formatting is a bit different from the test .xml file I used. Since editing formatting every time I want to import isn't really efficient, and since Access should be creating compatible files anyway, does anyone have any clue as to what might be going wrong and preventing MySQL from properly putting data under the correct fields?
Subject
Written By
Posted
Need help with importing data
February 09, 2016 08:10AM
February 10, 2016 06:49AM
February 16, 2016 08:29AM
February 16, 2016 06:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.