[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.