Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #7336

Re: XLS to DBF converter using VO SQL classes

From "Urs Eggmann" <Urs.Eggmann@shinternet.ch>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: XLS to DBF converter using VO SQL classes
Date 2014-10-20 11:25 +0200
Message-ID <cak2ocFgeisU1@mid.individual.net> (permalink)
References <edc6c694-8910-47ce-8ff2-531793024fae@googlegroups.com>

Show all headers | View raw


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" <rjpajaron@gmail.com> 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. 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

XLS to DBF converter using VO SQL classes "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-16 20:16 -0700
  Re: XLS to DBF converter using VO SQL classes "Urs Eggmann" <Urs.Eggmann@shinternet.ch> - 2014-10-20 11:25 +0200

csiph-web