Transfering information into a Paradox Table

[woodyinoz]

Hi all,

I am currently having a bit of trouble transferring data from an SQLBase table (Similar to MySQL) into a Paradox Table.

When I try and append using 'dataTransfer', Paradox tells me that I my 'Alias is a Server'.

This error occurs when using the following code
[tt]
dthandle.SetSource (":SQLBase:REQUIREMENT")
if dthandle.getSourceType ( ) = DTASCIIFixed Then
dthandle.loadDestSpec ( "SpecTable" )
endIf
dthandle.setDest ( "Requirement.db" )
if not dthandle.getAppend () then
dthandle.setAppend ( True )
endif
dthandle.transferData ( )
[/tt]
The reason I am not simply running a query to get my results is because some of the original tables fields allow 80 characters, and, although none of the information in these fields are actually 80 characters (most are 6-7) Paradox brings out all of the spaces and therefore my resulting answer table is to large.

Thanks in advanvce,

Woody.