Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7326 > unrolled thread
| Started by | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| First post | 2014-10-16 20:16 -0700 |
| Last post | 2014-10-20 11:25 +0200 |
| Articles | 2 — 2 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-10-16 20:16 -0700 |
| Subject | XLS 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]
| From | "Urs Eggmann" <Urs.Eggmann@shinternet.ch> |
|---|---|
| Date | 2014-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