Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7321
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Looking for sample code for Excel (XLS) to DBF |
| Date | 2014-10-16 19:05 +0200 |
| Organization | A noiseless patient Spider |
| Message-ID | <m1otsh$nl4$1@dont-email.me> (permalink) |
| References | <7fc961bd-e4be-4d9b-8249-6e9601fd7421@googlegroups.com> <m1jbek$95k$1@dont-email.me> <7fdf28a3-6b6e-4b2e-b21a-f13800a33210@googlegroups.com> |
There is (at least) one warning about using ODBC and the VO SQL classes. I sometimes have multiple rows/records that are filled with the exact same data. If you look in the XLS this is not true. I have these problems with XLS's where the last column is in some cases empty. These rows are shown INCORRECT by the SqlConnection. In my case I do not need this comlumn. I check for duplicate recods in my app and ask the user to delete this last column (using Excell of Calc) and save. Then there are no problems reading the data. Rene J. Pajaron schreef op 15-10-2014 om 5:50: > Hi John, > > Thanks. I will play on that one today. > > I will let you know. > > -- > > Rene > > On Tuesday, October 14, 2014 10:20:08 PM UTC+8, JohnMartens wrote: >> I send you a PM with some code of mine. >> >> Hope it can help >> >> >> >> John >> >> >> >> >> >> Rene J. Pajaron schreef op 14-10-2014 om 11:17: >> >>> Hello, >> >>> >> >>> I am already testing some code that converts XLS to DBF, probably also for XLSX in later. >> >>> >> >>> The problem is I have Excel 2013, not an older Excel (before ribboned UI). >> >>> >> >>> -- >> >>> >> >>> Rene >> >>> >> >>> PS: I am downloading samples at http://www.voug-bodensee.net/ but it appears it only deals with DBF to Excel. >> >>> >
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 02:17 -0700
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-14 11:50 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-14 12:00 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-14 15:14 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-14 23:17 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-15 07:35 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-15 10:57 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:37 -0700
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:15 -0700
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-15 07:39 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Fred Killet" <info@killetsoft.de> - 2014-10-14 16:06 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-14 16:23 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:55 -0700
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-15 10:55 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-15 20:05 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-16 20:15 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-16 22:52 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-17 11:59 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-17 15:02 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-14 17:24 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:49 -0700
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-14 16:20 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:50 -0700
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-16 19:05 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-17 17:18 -0700
Re: Looking for sample code for Excel (XLS) to DBF Sherlock <sherlock@sherlock.com.au> - 2014-10-16 00:36 -0700
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-16 14:02 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-17 17:15 -0700
csiph-web