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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.