473,741 Members | 5,161 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 3475

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

Similar topics

15
7393
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.
0
1431
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...
0
6685
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...
4
12725
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
3
3966
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...
3
4915
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,...
10
3599
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.
12
2725
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'@'192.168.1.2' (using password: YES) Is seems, this is most common problem for mySOL and phpMyAdmin. Extremelly ugly and inconvenient program.
39
5865
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;
0
8969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9484
Oralloy
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...
0
9342
jinu1996
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...
1
9272
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8218
agi2029
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...
0
4572
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4826
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3286
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2748
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.