PoRToSS Posted June 30, 2003 Report Share Posted June 30, 2003 Ljoti veelams prieksh shaadas operaacijas software risinaajums... Bet ja taada nav, tad varbuut vareetu paskaidrot kaa shaadu manevru var realizeet. Link to comment Share on other sites More sharing options...
RuncZ Posted June 30, 2003 Report Share Posted June 30, 2003 ieseivo to xls kaa tab delimiteeto txt un tad kaukaa ar pashu mysql, vai php scriptu ieparsee visu ieksh db... savulaik naacaas pasham taa dariit.. un nebij ne vainas. Link to comment Share on other sites More sharing options...
tamster Posted June 30, 2003 Report Share Posted June 30, 2003 Vai tik to nevarēja izdarīt saglabājot excel tabulu uz CSV un pēc tam importējot caur phpMyAdmin? Link to comment Share on other sites More sharing options...
Venom Posted June 30, 2003 Report Share Posted June 30, 2003 1ā pieeja: a) excelī sataisi kolumniem tādas pašas kolonnas, kā vajag tabulā > save as > comma delimited (comma separated values (csv)) B) ņem softu, kaut vai MySQL Front > import textfile un baro iekšā to csv. 2ā pieeja: a) Control Panel>ODBC connection pievieno Excela DNS (vienkārši iehavo viņam xls failu) - tad varēsi ar viņu "apspriesties" kā ar datu bāzi - taisi SELECT * INTO FILE ... ar spec. nosacījumiem B) vai nu ar MySQL Frontu atkal iebaro txt failu c) vai nu izmanto to pašu myqsl dzinuli un taisi LOAD * FROM FILE ... Link to comment Share on other sites More sharing options...
Recommended Posts