470,613 Members | 1,645 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

MySQL / PHPMyAdmin import from Access; txt's don't work!

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
corresponds to your MySQL server version for the right syntax to use near...

And then is followed by a text string of my field names separated by tabs.
In addition, in the big colored Error box, it shows the text value of a
couple fields, and I notice that a lot of SQL syntax words that happen to be
in the Access Memo field are highlighted (for example, if the sentence
that's in one of Access's memo fields is "This field requires that peaches
and cream should join in milk", the "AND" and "IN" and "JOIN" are
highlighted in green, which I assume means PHPMyAdmin (or MySQL) are trying
to parse and run the strings in my fields, instead of just importing them as
text data values to be put IN a field.

So, is it really true that text qualifyers cannot be used when exporting in
Access? It seems I need to somehow tell either MyAdmin or MySQL that this
is a table, not a SQL string. I notice that in MyAdmin's control panel, in
the part where you browse to import a text file, there is a "Format of
imported file" at the bottom left, with only a SQL radio button checked (ie.
I can't change the format; it's only SQL available as a choice). Is this
the problem? Don't I need to tell MyAdmin (or MySQL) that this is a text
file, not a SQL command?

Do I need to make the table in PHPMyAdmin first, and THEN use PHPMyAdmin to
make and name the fields and set their field data types, and THEN try to
import? I was under the impression I could just import a whole text file as
a table, without a whole bunch of preparation.

Can someone help me figure out exactly what needs to be done to import
Access tables into MySQL using PHPMyAdmin?

Also, assuming I somehow get this figured out, I also have HTML in some of
my Access tables' memo fields. This mdb was the back end for an ASP site,
and there is an option in Access and/or the FrontPage Data Results tool to
check YES for some fields containing html (which enables html code to be
written out of data in the table's fields). So, for instance, I can have
the value in a field be:

'<a href="blah.com">Click Here</a> to see further news on <more asp code
here to write the current record data>'

Will I run into problems with this down the road, like can MySQL not store
text and html code in fields?

Thanks for any help, and for reading.
Jun 17 '06 #1
0 3239

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by bettina | last post: by
reply views Thread by Donald Tyler | last post: by
4 posts views Thread by news | last post: by
10 posts views Thread by Simon | last post: by
12 posts views Thread by mistral | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.