>Hi,
>if my customer table is DBF file
>will
>sqlexec(han,"select cus_id into #temp from customer where 1 = 0")
>works?

John.
no .. customer here is inside the sqlexec statement, hence the supposition it is IN the MS-SQL database as table named 'customer' .

DID YOU SEE MY META CODE IN EARLIER ANSWER ?

hth - mondo regards [Bill]