Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7336
| 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> |
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
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