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


Groups > comp.lang.clipper.visual-objects > #7326 > unrolled thread

XLS to DBF converter using VO SQL classes

Started by"Rene J. Pajaron" <rjpajaron@gmail.com>
First post2014-10-16 20:16 -0700
Last post2014-10-20 11:25 +0200
Articles 2 — 2 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#7326 — XLS to DBF converter using VO SQL classes

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-10-16 20:16 -0700
SubjectXLS to DBF converter using VO SQL classes
Message-ID<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. 

[toc] | [next] | [standalone]


#7336

From"Urs Eggmann" <Urs.Eggmann@shinternet.ch>
Date2014-10-20 11:25 +0200
Message-ID<cak2ocFgeisU1@mid.individual.net>
In reply to#7326
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. 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web