[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] [PHP] Problem med danske tegn



David wrote:
Jørgen Heesche wrote:
David wrote:
... SKIP ...

sammenhængen mellem postnr. og bynavn (ud fra en tabel fyldt med data fra PostDanmarks famøse Excel ark med postnumre og bynavne). Her kan jeg se i MySQL loggen at der spørges f.eks. sådan mod databasen:
select * from city where city = 'Vanløse';

Tabellen kan downloades som: postnummerfil.xls.
Hvordan kan en excel-fil importeres til mysql?

I mit tilfælde ved at køre den gennem Gnumeric, som kan gemme CSV filer fra regneark ligesom man vil have det (m.h.t separator, linieskifttegn etc.). Derefter har jeg fra MySQL kørt 'load data .....' med filen som input.

Fint, det var lige den konvertering til tekst-format, jeg ikke vidste hvordan kunnne gøres. Og så vil jeg forøvrigt bruge charset latin1 i Mysql, så vil Firefox med ISO-8859-1 ikke have problemer med danske bogstaver.

--
Med venlig hilsen

Jørgen Heesche
mailto:sslug@sslug


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2008-04-01, 02:01 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *