]>, [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
> > there then importing it into a table.
>
>This part makes sense
> 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
chine [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
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
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 f
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 also use ODBC and some ActiveX control
under Visual Basic for quick and dirty transfer scripting.
- Original Message -
From: "Chris L. Gray" <[EM
Hi,
Yes, you can DBTools for Windows (http://dbtools.vila.bol.com.br) that
imports from MsAccess, Clipper, Dbase, FoxPro, Paradox, MSExcel and ODBC
databases.
[]'s
Crercio O. Silva
-Original Message-
From: Chris L. Gray [mailto:[EMAIL PROTECTED]]
Sent: quarta-feira, 6 de junho de 2001
7;,'
OPTIONALLY 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 spreadsh
s based on my information or do
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
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 spre
10 matches
Mail list logo
