Re: TZF -

There are also freeware components that do a variety of exports.

See:

http://www.maxcomponents.net


for one.

On Sat, 26 Apr 2003 08:17:05 -0400, Philip Kidder <[email protected]> 
wrote:

> 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
>>
>>
>
>
>
>



-- 
 Chris Johnson

==^================================================================
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
==^================================================================