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

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" <Urs.Eggmann@shinternet.ch>
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 <cak2ocFgeisU1@mid.individual.net> (permalink)
References <edc6c694-8910-47ce-8ff2-531793024fae@googlegroups.com>
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

Show key headers only | 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