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