I'm trying to import a .txt created in Word to the mysql database. All of the text was within tables within the WORD DOC. I converted the talbe to text with ^ seperating the data. Needless to say, the data gets mucked up on import due to several characters (returns, quotes, etc.). Rather than write a macro to take all of these out... I was wondering if there was a way to just use the tables as the separators. Any advice is more than appreciated. Hopefully someone can be a salvation this monday on my side of the world. Thanks in advance.
J