try this:
1. export the data from ms access to a file on
the windows box.
2. fire up ftp from the command line and set it
to ascii mode.
3. ftp the file from the windows box to the
linux box.
if the eol is the problem, the ftp protocol will
insure that the eol is correctly translated
Hi!
I have three large files containing MySQL commands. However, when
importing them using mysql -u [username] -p [database] file.sql, I get
an error:
ERROR 2006 at line xxx: MySQL server has gone away
From reading more at mysql.com, it seems that MySQL reads these large
packets as errors
Erica,
Thursday, October 17, 2002, 12:24:53 PM, you wrote:
ED I have three large files containing MySQL commands. However, when
ED importing them using mysql -u [username] -p [database] file.sql, I get
ED an error:
ED ERROR 2006 at line xxx: MySQL server has gone away
From reading more
Reformat your import file.
or
Add two columns , import, and drop the two columns.
or
Import to a six column temporary file and do an
insert into select from.
tl wrote:
Hello,
#If I have a file t.txt
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
# A table
Hello,
#If I have a file t.txt
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
# A table
CREATE TABLE userdata (
a1 varchar(128) NOT NULL default '',
a2 varchar(128) NOT NULL default '',
a3 varchar(128) NOT NULL default '',
a4 varchar(128) NOT NULL default '',
KEY a1
Hi,
I have data in CSV format file which has a date value
in the format 'dd/mm/yy'?
When i used 'Load data...' to import to a MySQL table,
all the fields gets the value from the file except the
date field that contains the date of birth??
is there any way to format and import???
Thanks
Regards
Sankaranarayanan,
Friday, October 11, 2002, 7:15:30 AM, you wrote:
SM I have data in CSV format file which has a date value
SM in the format 'dd/mm/yy'?
SM When i used 'Load data...' to import to a MySQL table,
SM all the fields gets the value from the file except the
SM date field that contains
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records in the table using below
mentioned command;
LOAD DATA INFILE 'user.txt' INTO TABLE
PROTECTED]
Subject: Urgent Help! Importing Data from Text File...
Importance: High
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill
wrote:
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But
when I
import the file, it only gets half of records in
- Original Message -
From: Nasir Aziz Gill [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 10:26 AM
Subject: Urgent Help! Importing Data from Text File...
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted
Hi - I am relatively new to MySQL, previous experience is mainly Visual
FoxPro and MS SQL2000.
I have a client who supplies data in text files. In numerous of these
files and subsequent tables there are date fields.
In the UK we use the date format of dd/mm/. I understand that MySQL
Hi Andrew,
DATE_FORMAT is the function you're looking for.
Check the documentation on it, chapter 6.3.4 Date and Time Functions.
DATE_FORMAT works like the following:
SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
BTW, SQL Server offers the CONVERT function for this purpose. No need
When I try to import a large (~180 mb) dump into mysql
$ mysql -uuser -ppassword db_name /tmp/all.sql
It dies on me after 2 minutes with this:
ERROR 2006 at line 1283716: MySQL server has gone away
I digged thru the manual, and tried running mysql with the -O
max_allowed_packet=16M option
rihad writes:
I digged thru the manual, and tried running mysql with the -O
max_allowed_packet=16M option as they suggested. Same thing. Exactly
same line. Always.
I opened up the file in [beep] (a text editor) and can see nothing
wrong at line 1283716. It's the end of the previous insert
Hi,
I used DbTools as Crecio O. Silva mentioned in his mail and I managed to
import Paradox tables to MySQL successfully..
There is still a problem with the imported data which are not imported
correctly because of the Greek chars that appear in the string fields.
Could anyone have a clue how
Hi,
I wonder if there is a utility for transferring Paradox tables to MySQL.
Nickos
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
On Tuesday 20 August 2002 05:52 am, Nick Lazidis wrote:
Its relatively straightforward to do it with a perl script.
Just set up an ODBC data source to the Paradox database and install perl DBI
and the DBD::ODBC and DBD::MySQL drivers. Then you can simply read records
from Paradox via ODBC and
, August 20, 2002 6:52 AM
Subject: Utility for importing Paradox tables to MYSQL
Hi,
I wonder if there is a utility for transferring Paradox tables to MySQL.
Nickos
-
Before posting, please check:
http://www.mysql.com
---
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2002 13:17
To: [EMAIL PROTECTED]
Subject: Re: Utility for importing Paradox tables to MYSQL
Hi Nick,
If you don't mind about the OS, yes there is. DBTools can handle Access,
ODBC, Excel, Paradox, FoxPro, ClipperDBase
I already have my table structure in place in MySQL, and I just want to
import the data from my Access 2000 database. (the .mdb is about 50 megs)
The MySQL server is on a Linux system.
I've been using DBTools to do the import, because it allows me to import
just the data, and not create the
Did you try to make an .csv file and then import it
with Mysql-Front?
I believe that both tables have the same structure.
--- Ian Zabel [EMAIL PROTECTED] : I already
have my table structure in place in MySQL,
and I just want to
import the data from my Access 2000 database. (the
, and then export
to MySQL from there.
Hope that helps...
-Original Message-
From: nick gatsis [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 1:42 PM
To: [EMAIL PROTECTED]
Subject: Fwd: Re: Importing into MySQL from Access
Did you try to make an .csv file and then import
Check out http://www.dbtools.com.br/EN/ I use it to import from access to
mysql. By the sounds of it though you have some dirty data which may or
may not need to be cleaned before going through there program. The only
real problem I had was that working with old dirty data is a pain since a
lot
do such crazy things in the first place.
Submitter-Id: submitter ID
Originator:
Organization: spamcop
MySQL support: licence
Synopsis: Crash importing old data to new server
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql
Hi,
Why don't you just dump the databases, tar.gzip them, and transfer that
file? It's smaller then the .frm+ .myd, and you can rebuild everything
without probs...
MPNeves
On Tuesday 30 July 2002 07:29 am, [EMAIL PROTECTED] wrote:
MySql crashes:
On an idle server, executeing
There appears to be a bug in the Win32 version of Mysql 2.23.49. When
I try to read data in (using the load data infile syntax) that
contains null values they are converted to 0s. The fields in question
are numeric, nulls allowed, default value is NULL. I tried coding
them blank, \N and NULL
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.I have two
problems. First is easy one,
First problem is to migrate big fields which had type varchar(7900) or
so I tried using Text datatype of mysql, is that the right one or I
should have used BLOB. That field doesnt contain any
...
Is this the only thing i need to do to get the data into mysql? And if i
do get this done will it then take on the properties of the tables that i
am importing, eg when i do a create table you have to specify the table
size etc.
As i said i am only new to this, and would like to thank anyone
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE c:/mysql/roma/mailmessagetext_table.txt INTO TABLE
Hi,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE c:/mysql/roma/mailmessagetext_table.txt INTO TABLE
Hi,
I am having two servers running Oracle and MySQL
database.
Views has been created for me in Oracle and I want to
import data from that Oracle table to my MySQL table.
I want a script like something main thing is I
want to import data from that Oracle database to MySQL
daily...like a
Hi all,
A colleague has created a database with MySQL. She has provided me three files
with the extensions .MYD .MYI .frm, to put them in the server. How can I
import
them into MySQL? I have MySQL 3.23.49 in Debian Linux 'potato'. I have used
myisamchk to check the database, but I do
by whomever the mysqld is
running as.
Harrison
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, May 04, 2002 1:41 PM
Subject: Newbee: importing data from .MYD .MYI .frm
Hi all,
A colleague has created a database with MySQL. She has provided me three
Hi, cannot seem to sucessfully make a simply link between Sage Line 50 and
MySQL. When accessing the tables the damn thing throws up errors and can
import structure but fails to import data. I am using MySQL-Front to do
this.
Anyone have any idea where i am going wrong or something to try. BTW
---
-Original Message-
From: Odyssea [mailto:[EMAIL PROTECTED]]
Sent: 10 April 2002 10:41
To: [EMAIL PROTECTED]
Subject: Sage Line 50 and importing into MySQL with ODBC
Hi, cannot seem to sucessfully make a simply link between Sage Line 50 and
MySQL
Everitte,
Monday, April 01, 2002, 11:28:31 PM, you wrote:
Eeoen I have the 3.23.49 Version of MySQL and it is saying the load data command
Eeoen does not work with this version. I also read in my book that any version
Eeoen past 3.22.15 should be able to complete this function. Please advise.
I have the 3.23.49 Version of MySQL and it is saying the load data command
does not work with this version. I also read in my book that any version
past 3.22.15 should be able to complete this function. Please advise.
Rosina M. Everitte, B.A., Research Assistant
University of Arkansas for
mysql version 3.23.41 ...i am having a problem importing simple date and
text data ( 6 fields) (from access 97).
this is what i have tried:
load data local infile 'client.txt'
into table client
fields terminated by '\t';
all 9 records imports correctly except that the quotes are still around
* Barbara Ferrell
only every other line imported correctly and there was a quote around the
Seems like there is a line ending problem... windows use CRLF as line
endings in text files, but mysql expects LF only... have you tried LINES
TERMINATED BY '\r\n';
CR = ascii 13 = \r = return (carrige
Hi David,
There is no built in tool for fix length records. If I am importing
the data once or just a few time I use M$ Access, just setup an ODBC
connection and use the import facility in Access to bring the file in
(it's very easy). Where I have to do this automaticaly I have written
perl
Hi. How can I import a text file containing all fixed-length records into
MySQL? Is there a way to do it with LOAD INFILE? The text file was
originally designed for import into Oracle. Thanks.
David
-
Before posting,
/y/mysqlimport.html
4.8.7 mysqlimport, Importing Data from Text Files
Mysqlimport provides a command-line interface to the LOAD DATA INFILE SQL
statement. Most options to mysqlimport correspond directly to the same
options to LOAD DATA INFILE. See section 6.4.9 LOAD DATA INFILE Syntax.
LINK/
http
Hi,
I'm looking to Import complete MS Access Table with
Data into a MySQL Database. How can i do that?
Especially if i have to do it for a site on the
internet...
Thanks,
T. Edison Jr.
__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th
separated values
files.
Use phpMyAdmin to insert text files into each table.
Voila!
Andrew Hazen
-Original Message-
From: Thomas Edison Jr.
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 12:52 PM
To: [EMAIL PROTECTED]
Subject: Importing Tables Data into MySQL from
On Thursday, 7. March 2002 07:18, Josiah Wallingford wrote:
Would the command by mysql -u
username -p password dbname filename.sql(mysql)
No, just use
mysql dbname -uusername -ppaswwod filename.sql
Regards
Georg
-
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW I know how to inport a .sql file into mysql by using mysql -u username -p
JW password filename.mysql(sql) but how do you import one that is made to go
JW into a database you already have created? Would the command by mysql -u
JW
At 12:06 +0200 3/7/02, Egor Egorov wrote:
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW I know how to inport a .sql file into mysql by using mysql -u username -p
JW password filename.mysql(sql) but how do you import one that is
made to go
JW into a database you already have
At 9:35 -0600 3/7/02, Paul DuBois wrote:
At 12:06 +0200 3/7/02, Egor Egorov wrote:
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW I know how to inport a .sql file into mysql by using mysql -u username -p
JW password filename.mysql(sql) but how do you import one that
is made to go
I know how to inport a .sql file into mysql by using mysql -u username -p
password filename.mysql(sql) but how do you import one that is made to go
into a database you already have created? Would the command by mysql -u
username -p password dbname filename.sql(mysql)
Thanks,
Josiah
I am in the process of migrating our data from m$ SQL Server to MySQL. I
am having a heck of a time trying to figure out how to deal with m$ SQL
Server's data type called 'uniqueidentifier'. I have tried very large
varchar's and blob's and even longtext but I always get datatype
conversion errors
I have a flat text file that is about 820mb I need to import into a database
that has the dates in the format MM-DD-. MySQL requires dates with the
year first and when I try importing test chunks of the data all I get is
zero's in the date field because of the dates being in the wrong format
into a database
that has the dates in the format MM-DD-. MySQL requires dates with the
year first and when I try importing test chunks of the data all I get is
zero's in the date field because of the dates being in the wrong format.
There are about 30 million records so editing the file is not feasible
Jeremy,
Apart from this perl of wisdom, how about defining two columns: one a 'temporary' text
field and the other the
'real date column - as proposed, and importing the date-data into MySQL in the
temporary-text field (and leaving
the other/real one empty). Then copy the data out
This is my first post on this list, so bear with me.
I have a text file with 10,000 stories in it (about 130 MB). I would
like to break it up into 10,000 separate files and am trying to figure
out a way to feed it into a MYSQL database.
I have set up the database with the pertinent fields,
, 2002 16:33
To: [EMAIL PROTECTED]
Subject: Importing large text file
This is my first post on this list, so bear with me.
I have a text file with 10,000 stories in it (about 130 MB). I would
like to break it up into 10,000 separate files and am trying to figure
out a way to feed it into a MYSQL
Greg, I agree with Tom H.
PHP can also do an excellent job of this, even as a standalone
script (ie no web server interaction). And you won't have to figure
out how to load the DBI module! I'll adapt an example
from something else I did: (Warning, not tested code...)
#!/usr/local/bin/php
?php
Hi,
How can I import a text file database in which delimiters are |
character field
separated into mysql database?
--
*** Phillip B. Bruce ***
*** http://pbbruce.home.mindspring.com
On Fri, Dec 14, 2001 at 03:16:56PM -0800, Phillip B. Bruce wrote:
Hi,
How can I import a text file database in which delimiters are |
character field separated into mysql database?
Crack open the manual and look for the section on *load data*.
The answer is there...
--
Regards,
Doug
Hello-
I created a schema for my database in MicroSoft Access
97. I would like to know if there is anyway to import
this schema into MySQL? PLease help.
Thank You
__
Do You Yahoo!?
Send your FREE holiday greetings online!
Hi,
-Original Message-
From: Hajar Abdus-Sabuur [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 7:29 AM
To: [EMAIL PROTECTED]
Subject: Importing for MicroSoft Access 97
Hello-
I created a schema for my database in MicroSoft Access
97. I would like to know
Damned filter. Anything quoted once is my post. Grrr...
database,sql,query,table
Erica Douglass writes:
I have a text file that is fixed-width delimited (that is, fields are
delimited by certain column widths.)
What is the workaround for this? Will importing large files work if I
Hi.
On Fri, Sep 21, 2001 at 02:31:44PM -0700, [EMAIL PROTECTED] wrote:
I'm having a difficult time synchronizing my Master and Slave Servers.
I've been doing this using MySQL Binary Logs, where the Master rotates the
logs at 1 hour times, and the slave downloads it and imports it.
What
Hello Laurent and jeroen!
I'm using mySQL/PHP on a macOSX machine and found myslf in trouble while trying
to import data from our filemaker pro database.
i've got the same problem with a french vocabulary database that I want to
import into a mySql database.
Has anyone seen
I'm having a difficult time synchronizing my Master and Slave Servers.
I've been doing this using MySQL Binary Logs, where the Master rotates the
logs at 1 hour times, and the slave downloads it and imports it.
What happens why I try to pipe the binlog into mysql is that it reports and
error
I'm having a difficult time synchronizing my Master and Slave Servers.
I've been doing this using MySQL Binary Logs, where the Master rotates the
logs at 1 hour times, and the slave downloads it and imports it.
What happens why I try to pipe the binlog into mysql is that it reports and
error
Mike wrote:
Is there a way to continualy update a MySQL database with an Excell file?
Reason:
Just to have some fun I am building a Code Red hall of shame in PHP and
MySQL. I am anoyed from cleaning XX's and NN's all day in my Apache
logs.And they call Open software Virul...
And
Of course. you COULD use Python, cleaner that Perl(tm) [jk no flames
please]
The advantage of Python, is that if you are using excel, you could go from
excel [via python] into MySQL. Or you could use Python in much the same way
that one could use Perl to process the log file. Of
Joshua M. Schmidlkofer wrote:
Of course. you COULD use Python, cleaner that Perl(tm) [jk no flames
please]
Sorry. If you don't program in hex assembly you are a wussy and you drink light
beer.
How is your ex-hell [excel] file being generated? Is it a .csv or is it
actually an XLS?
Is there a way to continualy update a MySQL database with an Excell file?
Reason:
Just to have some fun I am building a Code Red hall of shame in PHP and
MySQL. I am anoyed from cleaning XX's and NN's all day in my Apache
logs.And they call Open software Virul...
And Instead of complaining
-46307-382 Fax: +49-30-46307-388
- Original Message -
From: Bing Du [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 9:03 PM
Subject: Re: importing data
Please see section 6.17 of http://www.mysql.com/doc/index.html.
Bing
Bing Du [EMAIL PROTECTED], 979-845-9577
Is there an easy way or perhaps a utility to import a tab delimeted text
file of data into a mysql table
Thanks,
--
Kevin Fonner
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
]
Subject: importing data
Is there an easy way or perhaps a utility to import a tab delimeted text
file of data into a mysql table
Thanks,
--
Kevin Fonner
-
Before posting, please check:
http
http://www.mysql.com/doc/L/O/LOAD_DATA.html
http://www.mysql.com/doc/m/y/mysqlimport.html
http://www.mysql.com/doc/L/o/Loading_tables.html
On Tue, 7 Aug 2001, Kevin Fonner wrote:
Is there an easy way or perhaps a utility to import a tab delimeted text
file of data into a mysql table
Please see section 6.17 of http://www.mysql.com/doc/index.html.
Bing
Bing Du [EMAIL PROTECTED], 979-845-9577
Texas AM University, CIS, Operating Systems, Unix
Kevin Fonner [EMAIL PROTECTED] 08/07/01 10:08AM
Is there an easy way or perhaps a utility to import a tab delimeted
text
file of
-
From: Kevin Fonner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 5:08 PM
Subject: importing data
Is there an easy way or perhaps a utility to import a tab delimeted
text
file of data into a mysql table
Thanks,
--
Kevin Fonner
Glyndower schrieb am Freitag, 3. August 2001, 05:37:15:
The error message says :MySql said: qUERY WAS EMPTY. When I try to import
this data.
looks like phpMyAdmin does not get the correct query. You have
the source code of phpMyAdmin. Look into that, insert some
debugging code and fix the
I've included my text file as an attachment, but a sample of that data is
below, for those who arn't playing with attachmnets nowadays... :)
I'm using phpmyadmin and I' (still) trying to import a text file into an
existing table. I've included the feils names in the attachment for
reference,
into this field.
I'm pretty sure the import is chocking on the carriage returns used in
the longer descriptions in some records. Does anyone know a way of
getting around this problem and getting it to import properly.
Basically the settings I use for importing are: Records seperated by
tab, nothing is used
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
mysqldump databasename | gzip databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
, I was just kidding.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Eugénio Veiga [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 12:12
Subject: Importing a complete database
Hi
Is it possible to import
PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 12:12
Subject: Importing a complete database
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
-
Before
into dbo.mySQLEXELDB select * from ACCESSEXELDB
And that is that..
hope it makes more sense
Johannes
At 16:19 06/06/2001 -0600, you wrote:
From: Johannes Pretorius [EMAIL PROTECTED]
Date: Wed, 06 Jun 2001 16:49:45 +0200
To: Chris L. Gray [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Importing
Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about
2,500 retail locations that I must place into a database on the web and I do not want
to type them by hand if I can avoid it.
Thanks,
Chris Gray
---
Outgoing mail is certified Virus Free.
Checked by AVG
Save as .csv file and then use http://www.mysql.com/doc/L/O/LOAD_DATA.html
Hope this helps
Simon
-Original Message-
From: Chris L. Gray [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 14:15
To: [EMAIL PROTECTED]
Subject: Importing spreadsheet data into MySQL
Is it possible to import
I need to have a table built to house the data BEFORE I import?
Chris Gray
- Original Message -
From: Roger Karnouk [EMAIL PROTECTED]
To: Chris L. Gray [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 9:36 AM
Subject: RE: Importing spreadsheet data into MySQL
Using Excel you can save
ENCLOSED BY ''
LINES TERMINATED BY '\n';
This should work I guess
-Original Message-
From: Chris L. Gray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 10:36 AM
To: Roger Karnouk
Cc: [EMAIL PROTECTED]
Subject: Re: Importing spreadsheet data into MySQL
Thanks for the response
10:15
To: [EMAIL PROTECTED]
Subject: Importing spreadsheet data into MySQL
Is it possible to import spreadsheet data (Excel) into MySQL? I have data on
about 2,500 retail locations that I must place into a database on the web
and I do not want to type them by hand if I can avoid it.
Thanks
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 5:15 PM
Subject: Importing spreadsheet data into MySQL
Is it possible to import spreadsheet data (Excel) into MySQL? I have
data on about 2,500 retail locations that I must place into a database
on the web and I do not want to type
On Wed, 6 Jun 2001, Chris L. Gray wrote:
Is it possible to import spreadsheet data (Excel) into MySQL? I have
data on about 2,500 retail locations that I must place into a
database on the web and I do not want to type them by hand if I can
avoid it.
One way:
Save as CSV file.
Parse CSV file
It is actually a little tricky. You need to build the table in mysql yourself, then
use some utility to import it. I would use perl. The problem with Excel is that when
it exports csv, it does not quote empty fields (I think), So, you can't use
Text::ParseWords (AFAIK). Here is a regexp which
Hi there
Yes you can do this by going into Access and op[ening the XLS file from
there then importing it into a table.
This meaning you have a database from where you can move it over to mySQL's
table via ODBC connection or how
you like moving it from DB to DB.
I hope this helps
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 11:03 AM
To: Chris L. Gray; [EMAIL PROTECTED]
Subject: Re: Importing spreadsheet data into MySQL
There is a module for Perl which can read Excel. Then there is
DBI for
accessing MySQL. Use both to transfer data.
If under Windows, you coudl
From: Johannes Pretorius [EMAIL PROTECTED]
Date: Wed, 06 Jun 2001 16:49:45 +0200
To: Chris L. Gray [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Importing spreadsheet data into MySQL
Hi there
Yes you can do this by going into Access and op[ening the XLS file from
. For instance,
the work 'Köln' (the second character here should be an o with an umlaut on it) goes
all wrong. I do know that the export runs fine, since after opening the
comma-delimited file with a text-editor such as BBEdit (a macOSX thingie) the
characters show up correctly.
When importing
i want to import a series of text files into a MySQL database..
can anyone point in the direction of good documenation on this?..
thanks in advance..
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Fri, Jun 01, 2001 at 03:08:53PM -0400, Longo, Joseph wrote:
i want to import a series of text files into a MySQL database.. can
anyone point in the direction of good documenation on this?..
Search for LOAD DATA in the manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny,
Hello,
I am trying to transfer my Microsoft SQL Server to a MySQL Server running
under Linux.
Until now I have tryied the following methods.
I installed DBtools 1.0.8 in a third machine running Win98 and connected to
the MySQL server (Linux). I tried to import data from the Microsoft SQL
I'm in the process of moving SQL data from one server to another (Linux) -
The tables on the new DBase server are not identical to the old - Is there a
way to import only specified fields data from the old to the new ?
Thanks in advance,
Regards,
MB
301 - 400 of 421 matches
Mail list logo