Hello everyone. I hope someone can help me with the following problem. I have a database in MS Access that I export as a .txt then load into a mysql table via "load data local infile 'file'". However, one of the fields in my Access db is really messing up this usually smooth process. I have a memo field that stores large chunks of text. I have returns and spaces in the field and Access does not like that at all. So I decided to try and put html tags right into the field but that doesn't work either! I am trying to get this info into access and I can't. I am exporting tab delimited, no text qualifier (which almost always works). Can anyone tell me what is going wrong?
Large text fields in MS Access
- Thread starter wxdqz
- Start date