Re: TZF -

Jerry,

I purchased a set of components that will read directly from Excel
spreadsheet. One of my clients creates several spreadsheets that I use to
update a database. It is a lot easier to use these components then have them
create CSV files.

I use my other computer for programming and it is off line right now, I will
have it up later today and will send you the name of the components. They
only cost $30.00 and are fast once you get the secret to using them.

Phil Kidder


----- Original Message -----
From: "Jerry Mallett" <[email protected]>
To: <[email protected]>
Sent: Saturday, April 26, 2003 6:28 AM
Subject: TZF -


> I seem to be having trouble accessing the Topaz For Delphi Forum.
> ( Server Not Found coming up a lot.  But I'm in now.  )
>
>
> I have an MS Excel spreadsheet which I have exported/saved as a "Comma
> Delimited file" CSV which seemed to work ok.
>
> I then used the TOPAZ routine AppendFromDelimited to import it to a dbf
> file.  Again it worked but....two of the fields lost their first
> characters.
>
> They are in the CSV file but the TOPAZ function seems to have dropped
> them for some reason.  Is there a bug in the routine that I am not aware
> of.
>
> I'm using Topaz v7.5 with Delphi v5
>
> Sample of CSV file below.......
>
> Format is
> Membership Number, Firstname, lastname, result, venue, instructor
>
> 100,Fiona,Hoy,under 8 newcomer,1st,Mellon Omagh,Rosita Shekleton
> 101,Sarah,Kelly,under 8 newcomer,2nd,Mellon Omagh,Rosita Shekleton
> 102,Sean Og,Irwin,under 8 newcomer,3rd,Mellon Omagh,Rosita Shekleton
> 103,Kathleen,Clerkin,under 8 newcomer,4th,Mellon Omagh,Rosita Shekleton
>
> The first character of FirstName and the first character of VENUE get
> dropped on every record.
>
> Many Thanks....
>
>
> Top O the Morning to ye one and all
>
>

==^================================================================
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
==^================================================================