spreadsheet data into MySQL
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 part makes sense
This meaning you have a database from where you can move it over to mySQL's
table via ODBC connection
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
12 matches
Mail list logo