473,883 Members | 1,709 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3486

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 atmosphere. Good food.", " (Harry Houdini - 03/01/2004)"); INSERT INTO `reviews` VALUES("", "Le Chow Place", "Lunch", "yada yada", " (Herbert Hoover - 03/03/2004)"); INSERT INTO `reviews` VALUES("", "Golden Dragon", "Lunch", "Exquisite.
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 send everything to my server. The provider supports MySql and PHP. Should I first reproduce the structure of my local DB with phpMyAdmin on my server? And then import the data? In phpMyAdmin I see only the button Exportieren... Should I export from...
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 be able to place the PHP file on the server, and I guess you probably can't do that either. Talk about catch 22... The only other way I can think of is to install MySQL on a machine you control, then import the data there using the method I...
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 though the file may be too big! When I try to do it via command line: mysql -u root --host=localhost printing < ./printing.txt It eventually errors out with a "syntax error on line X" and only about
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 NT/Linux Servers. After exporting the database with phpMyAdmin I tried to import it to a Linux server with the mysql>source file.sql command via a ssh access (the file is 40 Mbytes so phpMyAdmin is useless). Everything seemed ok but all accented...
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 file type dropdown, selected "New data source" and picked SQL Server from the list. I specified the server name (mydomain.com) along with user id and password. But when I clicked on "Next", I got: "connection failed: SQL Server Error:10060,...
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 only work on win32 machines but the servers are Unix machines. I don't have command line access to the servers.
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 problem for mySOL and phpMyAdmin. Extremelly ugly and inconvenient program.
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 ISO-8859-1 -t UTF-8 mydb.sql mydb_utf8.sql mysqlCREATE DATABASE mydb_utf8 CHARACTER SET utf8 COLLATE utf8_general_ci;
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.