472,780 Members | 1,790 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,780 software developers and data experts.

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 3394

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

Similar topics

by: Jack | last post by:
I have a text file of data in a file (add2db.txt) where the entries are already entered on separate lines in the following form: INSERT INTO `reviews` VALUES("", "Tony's", "Lunch", "Great...
by: bettina | last post by:
I had originally an Access DB. Then I created the same structure with phpMyAdmin and exported my Access DB to MySql. It was located under mysql/data.... and everything was ok. Now I wanted to...
by: Donald Tyler | last post by:
Then the only way you can do it that I can think of is to write a PHP script to do basically what PHPMyAdmin is trying to do but without the LOCAL in there. However to do that you would need to...
by: news | last post by:
Our production database in an exported textfil runs about 60 MB. Compressed that's about 9 MB. I'm trying to import the export into another machine running FC3 and mySQL 11.18, and it appears as...
by: Daedalus.OS | last post by:
Hi, I've been asked to transfert a database from a webhoster to another. I think the database is on a windows box but I'm not 100% shure. The webhoster says it provides combined hosting on...
by: Xerxes | last post by:
Hi, I would like to import the tables from MySQL database into Access database and I am not sure how to go about it. I tired to "Import External Data" from Access, selected "ODBC database" from...
by: Simon | last post by:
Hi, I need to export a 200MB database from one domain to another. phpMyAdmin timeout after a while and is not ideal. I don't mind spending money if I have to but this is rather urgent. I...
by: mistral | last post by:
phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time shown error #1045 - Access denied for user 'username'@'' (using password: YES) Is seems, this is most common...
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
How does React native implement an English player?
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.