Check this out:
http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm

Step by step instructions on how to connect Access to MySQL (from PC/workstation to 
remote server)

Cheers.
Russ

On Thu, 18 Oct 2001 13:44:15 +0100 Tony McCrory <[EMAIL PROTECTED]> wrote:

> You could try the MyODBC driver.  On the www.mysql.com website I think.
> Then you won't need CSV or any other type of import file.
> 
> Tony
> 
> > -----Original Message-----
> > From: Mikusch, Rita [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 17, 2001 5:05 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] RE: Excel to MySQL
> >
> >
> > I do this fairly often (actually from MSSQL to Access to Excel to MySQL --
> > I'm sure there's a shorter route!)
> >
> > I convert the Excel file to a tab delimited file. I do run into two
> > problems:
> >
> > a) some of the text entries are surrounded by double quotes and
> > some aren't
> > (some kind of Excel weirdness). So I open it up in a text editor
> > and delete
> > all the quotes. I use the "programmers file editor" which is
> > about a zillion
> > years old, hasn't been updated for years, but deletes those quotes in
> > milliseconds.
> >
> > b) sometimes users enter hard-returns into the text data they
> > enter into the
> > windows database (the source of my excel file). This will convert into a
> > hard return in your tab delimited text file. I run through the
> > list manually
> > to find the hard returns and delete them. My list is only 10,000
> > long and it
> > is formatted in such a way that makes these hard returns easy to see! I'm
> > sure others on the list have a much better way of dealing with this.
> >
> > I have an "auto increment" field in my table so I add an
> > additional numbered
> > column in Excel and number it appropriately.
> >
> > One day when I have time I'll actually find a more efficient way of doing
> > all this!
> >
> > good-luck
> > rita.
> >
> > -----Original Message-----
> > From: Chris Payne [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 16, 2001 10:58 PM
> > To: [EMAIL PROTECTED]
> > Subject: Excel to MySQL
> >
> >
> > Hi there everyone,
> >
> > What is the best way to convert an Excel spreadsheet into a MySQL
> > database?
> > Should I save it as a comma'd file or is there a better way?  If I have to
> > save it as a comma'd text file, is there anything special I
> > should do first?
> >
> > I would normally enter the data manually on my server, but we are
> > talking in
> > excess of 15000+ entries here which is way too many to add manually.
> >
> > Thanks for all your help.
> >
> > Chris
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

#-------------------------------------------------------#
                                
  "Believe nothing - consider everything"       
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com
                        
#-------------------------------------------------------#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to