Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!news2.arglkargh.de!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Urs Eggmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: XLS to DBF converter using VO SQL classes Date: Mon, 20 Oct 2014 11:25:22 +0200 Lines: 43 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Trace: individual.net ACaLLkZ7jAhU6xQp1//ACwGqKJAWSxQLnrc6aao63X0/4e2EEu Cancel-Lock: sha1:8DM3yfAZwRa/p1nv6nT5C84yVSw= X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-EsetId: 37303A2992966F62637D63 X-EsetScannerBuild: 20680 Xref: csiph.com comp.lang.clipper.visual-objects:7336 Hi Rene, Norbert Kolb hat updated his sample for converting DBF to EXCEl and vice versa. You can find it on the download page of the Usergroup-Bodensee: www.voug-bodensee.net Regards Urs "Rene J. Pajaron" schrieb im Newsbeitrag news:edc6c694-8910-47ce-8ff2-531793024fae@googlegroups.com... > Hello Everyone, > > Thanks to John Martens, Wolfgang, and all the replies I have got in the > similar thread posted days ago. > > I am now writing my converter using VO SQL Classes with its samples as > starting point (and code samples shared to me) and able to open and browse > Excel 2003 file without DSN settings in ODBC manager. > > The only question/comments I have is that: 32-bit and 64-bit drivers are > different and must be set separately for 64-bit windows. It appears that > there is no 64-bit XLSX driver, but I have yet to test using 32-bit ones > that appears to be supporting XLSX. > > From: C:\Windows\SysWOW64\odbc32.exe -> "Microsoft Excel Driver (*.xls)" > > From: C:\Windows\System32\odbc32.exe -> "Microsoft Excel Driver (*.xls, > *.xlsx, *.xlsm, *.xlsb)" > > So, it appears the 32-bit supported latest Excel file formats. > > Anyway, my target client is using Excel 2003 anyway and I am planning to > implement this to other clients with firm instruction to Save As Excel > files to 2003 standard prior to conversion. > > -- > > Rene > > PS: I will resume my OLE adventure when I need to update an Excel file > with DBF as source.