Hello folks,
What is the best way to import an excel spreadsheet, or text file for
that matter into a table?
Is there a way to do this with PHPMyAdmin?
Thank you so much for your kind help.
Joe
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote on 08/09/2005 01:52:58 PM:
>
> All,
> Could you tell me how to import data (file.txt)with BLOB column to
mysql?
>
> Thank you
>
> Nguyen
>
>
The "short answer" is: you escape the content of the f
All,
Could you tell me how to import data (file.txt)with BLOB column to mysql?
Thank you
Nguyen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I imported data into a table "mytable" into a databse "mydb" with existing
data.
mysqlimport -L mydb data.txt
that operation failed.
I interrupt it.
It seems that I imported data with the same indexes (duplicate entries)
I tried: delete from mytable;
that seems to fail too
What happens whe
-
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Ehrwin Mina" <[EMAIL PROTECTED]>
Subject: Re: How to import data from Dbase3?
Date: Wed, 23 Mar 2005 02:21:48 -0600
Ehrin,
If you have dBase III or later, Clipper or FoxPro, you can export
the data comma-separat
o
On Wed, 2005-03-23 at 17:34, Karam Chand wrote:
> If Dbase3 has an odbc driver then you can use SQLyog
> (www.webyog.com) to import data to MySQL.
>
> Karam
> --- "Peter L. Berghold" <[EMAIL PROTECTED]> wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> >
If Dbase3 has an odbc driver then you can use SQLyog
(www.webyog.com) to import data to MySQL.
Karam
--- "Peter L. Berghold" <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> BG Mahesh wrote:
> > Actually I prefer to dump the d
Hi,
How do I import data from Dbase3 into MySQL?
My software, libmygis, is mainly designed for loading a set of
Shapefiles into MySQL (.SHP, .SHX, .DBF) but it's perfectly well capable
of loading just the dBase III/IV component. Grab libmygis-0.5.1 from:
http://jcole.us/software/lib
If you have ms access you can import the db3 into access and then export
thru odbc to MySql
Osvaldo Sommer
-Original Message-
From: BG Mahesh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 10:33 PM
To: mysql@lists.mysql.com
Subject: How to import data from Dbase3?
hi
How do
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG Mahesh wrote:
> Actually I prefer to dump the dbase file on a Linux machine and directly
> import it into MySQL.
>
>
There are a bunch of ways of skinning that cat. The easiest of which
IMHO is to convert the data to comma separated files first
I remember seeing some JDBC drivers for Java to read dbase 3 files. So
it might be a good idea to use that to understand the files and import
the data using the mysql jdbc drivers into the mysql database.
We can help you do it (provided you pay) since we have already done
similar exercise for a
Actually I prefer to dump the dbase file on a Linux machine and directly import
it into MySQL.
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Ehrwin Mina" <[EMAIL PROTECTED]>
Subject: Re: How to import data from Dbase3?
Date:
script.
If there's a memo file, you need an xbase executable.
PB
-
Ehrwin Mina wrote:
BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
BG,
There are tools you can use to migrate it to mysql, i use it before
th
Do you want to do a one time import ?
Create an ODBC source that maps to the dBase datasource and write an
application to read it from there and import into mysql.
- Navneet
BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com
BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
BG,
There are tools you can use to migrate it to mysql, i use it before that
i get it in the forum. You can search some forum indicating the
migration tools for DB3
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
--
__
IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com
Check out our value-added Premium features, such as an
I have a table with 9 columns, one is an auto_increment for primary key.
Data set:
2004-09-21 10:35:50,2004-09-21
10:45:48,tcp,111.111.111.111,80,222.222.222.222,1555,4700
Currently I just dump everyting into one table and query it that way. I was hoping to
learn how to place the data into diff
EMAIL PROTECTED]>
Sent: Jan 9, 2004 6:16 PM
To: [EMAIL PROTECTED]
Subject: import data from text files
hi list ,
I've got two problem with mysql , maybe it is not a real 'problem' but i need
help hardly ! :)
1 > in a table , we got many record ( 1400 ) , some of them are equa
* Armin
> I've got two problem with mysql , maybe it is not a real
> 'problem' but i need help hardly ! :)
>
> 1 > in a table , we got many record ( 1400 ) , some of them are
> equal , i want to delete just one of them , in other word , i don't
> want two record equal .
Take a look at SELECT
hi list ,
I've got two problem with mysql , maybe it is not a real 'problem' but i need
help hardly ! :)
1 > in a table , we got many record ( 1400 ) , some of them are equal , i want
to delete just one of them , in other word , i don't want two record equal .
2 > i got a text file , which m
Hi,
A cohort wrote a script to import tab delimited files. He uses
mysqlimport. He uses the -d option to ONLY empty the data from the
table before importing the new data. My cohort believes that
mysqlimport is also dropping the table and then recreating the table
from somewhere and then insert
In the last episode (Oct 20), Peter J. Schoenster said:
> A cohort wrote a script to import tab delimited files. He uses
> mysqlimport. He uses the -d option to ONLY empty the data from the
> table before importing the new data. My cohort believes that
> mysqlimport is also dropping the table and t
Hi Riccardi,
>
> I want to import data from text file that contains decimal number
> (occasionaly with 9 decimal) but mysql import only 2 decimal.
> My columns is set to DECIMAL(6,9)
> Hi, Moreno
>
try
DECIMAL(15,9)
because I think the first argument specifies the tota
Riccardi Moreno wrote:
> I want to import data from text file that contains decimal number
> (occasionaly with 9 decimal) but mysql import only 2 decimal.
> My columns is set to DECIMAL(6,9)
Someone correct me if I am wrong: The '9' is how many decimal places after
the perio
I want to import data from text file that contains decimal number
(occasionaly with 9 decimal) but mysql import only 2 decimal.
My columns is set to DECIMAL(6,9)
Hi, Moreno
-
Before posting, please check:
http
hrer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 10
Date |Mon, 6 Aug 2001 13:48:41 -0700
>From |[EMAIL PROTECTED]
Hello!
C> I have a table I want to import some records into. The table has 4 columns
C> -
C> user_id, name, account, password.
C> The file I have to be imported has 3 columns -
C> password,name,account.
C> I have been trying to use lo
I have a table I want to import some records into. The table has 4 columns
-
user_id, name, account, password.
The file I have to be imported has 3 columns -
password,name,account.
I have been trying to use load data infile and keep ending up with a lot of
junk in the database.
The file is of this
Hi All,
I need to import about 30,000 data records from a text file into a MySQL
database table, thru the LOAD DATA feature. The table in question will have a
auto increment column, plus 5 other columns. Should I include a field in the
text file to insert a value into the auto increment column,
29 matches
Mail list logo
