Inputting information into a table

[woodyinoz]

Hi all,

I am looking to populate an empty table with information from a table held within an SQLBase table.

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

Can anyone suggest an alternative to the coding below so that I can carry out what I'm trying to do?

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

Thanks in advance,

Woody