What you do after you have it in a Acces Database is make a table that
looks like the Acces Database
in MySQL. And then create a ODBC connection to that Table.
Then you run a Query that inserts all the data into the mySQL database
from the Acces database like
follow :
insert 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 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 or how
> > you like moving it from DB to DB.
>
>This part I don't understand, can you mention more about how you get a MS
>Access file on a WIndoze box over to MySQL on a Linux box?
>
>Chris
>
> >
> > I hope this helps
> >
> > Johannes
> >
> >
> > At 08:15 06/06/2001 -0500, you 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.
> >>
> >> Thanks,
> >>
> >> Chris Gray
> >>
> >>
> >> ---
> >> Outgoing mail is certified Virus Free.
> >> Checked by AVG anti-virus system (http://www.grisoft.com).
> >> Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
