Hi,

Is there a way to export data as .sql format?.... Thanks.

K.C.

Maybe. Is there an authoritative reference documenting the format?

The format of the sql format is as followed:

INSERT INTO #__abbook (id,title,subtitle,alias,ideditor,price,pag,user_id,created_by_alias,html,image,file,year,idlocation,idlibrary,vote,numvote,hits,published,ordering,catid,qty,isbn,approved,userid,url,url_label,dateinsert,catalogo,checked_out,checked_out_time,access,metakey,metadesc,note,editedby) VALUES ('1','參考書 ','','-','0','','0','62','','','','','0','0','0','0','0','0','1','1','1','','','0','','','','2012-02-27 23:03:00','','0','0000-00-00 00:00:00','0','','','','0');

The background of my project is that I want to have a .sql format so I can import the data in my website with joomla extension Alexandria book library.

I can't do it in csv because my file has Traditional Chinese. Many Thanks.

K.C.