Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #7321

Re: Looking for sample code for Excel (XLS) to DBF

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>

Show all headers | View raw


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


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