[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Sheflug] MySQL help
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wednesday 24 April 2002 12:19, Steve Tickle wrote:
> Could someone help me on this one (not a thoroughbred Linux question,
> I accept)
>
> I'm trying to populate a MySQL table with data which is actually held
> in an Excel worksheet. The problem is that when I save the worksheet
> as a text file some of the data gets out of skew. Is there any other
> file format I can import the data from, whether by using "load data
> infile" or any other method?
I was looking at this last week, and came up with this link which
might be what you want:
.
http://www.flatmysql.com/help/excel.htm
I don't know how well it will work (I want to use it for numerical
data myself), but I'd be willing to know how you're getting on...
Jose
- --
José L Gómez Dans PhD student
Tel: +44 114 222 5582 Radar & Communications Group
FAX; +44 870 132 2990 Department of Electronic Engineering
University of Sheffield UK
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD4DBQE8xqUkJfBvR9HO55wRAhwfAJjDqMa/9+dNd9lzyh8WBYclinXgAJ97UsUo
TFhLPMxJ6UdMRFxZJoCMXA==
=rr8u
-----END PGP SIGNATURE-----
___________________________________________________________________
Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html
GNU the choice of a complete generation.