etdsbastar Posted August 26, 2011 Share Posted August 26, 2011 Hello there, I am having lots of data in Openoffice Spreadsheet format, I want to import all those into my MYSQL table. How can I do that? One more thing, the data is in UTF-8 (Indian Language) format, i.e. in other language which uses reserved field and text delimiter characters like ', ", ;, {, }, (, ), |, \, / etc. etc. Anybody please help, its very urgent. Link to comment https://forums.phpfreaks.com/topic/245763-how-to-import-oo-spreadsheet-data/ Share on other sites More sharing options...
Muddy_Funster Posted August 26, 2011 Share Posted August 26, 2011 save them as csv and use LOAD DATA INFILE - see http://dev.mysql.com/doc/refman/5.1/en/load-data.html Link to comment https://forums.phpfreaks.com/topic/245763-how-to-import-oo-spreadsheet-data/#findComment-1262314 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.