Hello Get link Facebook X Pinterest Email Other Apps - February 08, 2015 Hello,i have an Excel 2007 file with over 800 students, i want to convert it (Export) to DBF, can anyone help ? Get link Facebook X Pinterest Email Other Apps Comments Steve MaughanFebruary 8, 2015 at 5:17 AMI'd suggest using either a python or r scriptReplyDeleteRepliesReplyZoran BonušFebruary 8, 2015 at 6:04 AMLibreOffice Calc can open the xls file and then File - Save as ... and choose format DBF. Maybe MS Excel can do the same, not sure.ReplyDeleteRepliesReplyJimmy HFebruary 8, 2015 at 6:09 AMOr save as CSV and write a simple script / program to put it into a DBF database.ReplyDeleteRepliesReplyStefan GlienkeFebruary 8, 2015 at 6:44 AMThere are free xls to dbf converters out there.ReplyDeleteRepliesReplyDelphi IDEFebruary 8, 2015 at 7:44 AMthanks for all, but i'm looking for a free tools, or a Delphi function that do the job, i test Exportizer but he didn't export unicode !ReplyDeleteRepliesReplyThomas Mueller (dummzeuch)February 8, 2015 at 8:05 AMYou can read Excel files as database tables using ADO and then use them any way you like, including saving them as DBF. The fastest way to convert it manually would be Excels save as function.ReplyDeleteRepliesReplyDelphi IDEFebruary 8, 2015 at 8:21 AMThomas Muellerthznks for tipsReplyDeleteRepliesReplySteve MaughanFebruary 8, 2015 at 9:40 AMThomas Mueller unfortunately the latest versions of Excel do not save DBF filesReplyDeleteRepliesReplyThomas Mueller (dummzeuch)February 8, 2015 at 11:29 AMIsn't progress great? OK, then use OpenOffice calc.ReplyDeleteRepliesReplyRobert LawrenceFebruary 8, 2015 at 3:25 PMI use Open Office 4 and it has a export to DBASE .dbf optionReplyDeleteRepliesReplySteve MaughanFebruary 9, 2015 at 5:12 AMRobert Lawrence Thanks - I missed this. DBF files are important to me as they are part of the GIS ShapeFile standard. So this is helpful.ReplyDeleteRepliesReplyDelphi IDEFebruary 9, 2015 at 8:03 AMi test with Access and it do the job except for Arabic characters.does OpenOffice support Arabic chars?ReplyDeleteRepliesReplyAdd commentLoad more... Post a Comment
I'd suggest using either a python or r script
ReplyDeleteLibreOffice Calc can open the xls file and then File - Save as ... and choose format DBF. Maybe MS Excel can do the same, not sure.
ReplyDeleteOr save as CSV and write a simple script / program to put it into a DBF database.
ReplyDeleteThere are free xls to dbf converters out there.
ReplyDeletethanks for all, but i'm looking for a free tools, or a Delphi function that do the job, i test Exportizer but he didn't export unicode !
ReplyDeleteYou can read Excel files as database tables using ADO and then use them any way you like, including saving them as DBF. The fastest way to convert it manually would be Excels save as function.
ReplyDeleteThomas Mueller
ReplyDeletethznks for tips
Thomas Mueller unfortunately the latest versions of Excel do not save DBF files
ReplyDeleteIsn't progress great? OK, then use OpenOffice calc.
ReplyDeleteI use Open Office 4 and it has a export to DBASE .dbf option
ReplyDeleteRobert Lawrence Thanks - I missed this. DBF files are important to me as they are part of the GIS ShapeFile standard. So this is helpful.
ReplyDeletei test with Access and it do the job except for Arabic characters.
ReplyDeletedoes OpenOffice support Arabic chars?