You're welcome. I've updated my message - but you can simply check APPEND FROM command in Help.

>>>Can someone tell me what's wrong with my syntax on this?
>>>

>>>numfolders = adir(aFolders,'j:\*.*')
>>>
>>>create table myFolders (cName c(40),filesize N(10), filedate D ) from array aFolders
>>>

>>>Thanks
>>
>>I believe you should be looking into append from command in your case. The array for CREATE TABLE should be a result from AFIELDS, not adir.
>>
>>See in Help
>>
>>----------------
>>FROM ARRAY ArrayName
>>Specifies the name of an existing array whose contents are the name, type, precision, and scale for each field in the table. You can use the FROM ARRAY clause instead of specifying individual fields in the SQL CREATE TABLE statement. For the proper format of the contents of the array, see AFIELDS( ) Function.
>>
>>Autoincrementing is turned on when StepValue is greater than 0.
>
>AHHH . . . OK Thanks.
>I was just working from the intellisense help.