Thanks. fully specivied the output folder and no icons.

I knew it was simple but I quess I was having a senior moment.

>You should either change current VFP directory to the one where you want a table to be created or specify full table name including directory

CD (lcMyDir)
>Select ...
>         .
>   FROM ...
>   INTO TABLE name NOCONSOLE
>* OR
>Select ...
>         .
>   FROM ...
>   INTO TABLE (lcMyDir + "name") NOCONSOLE
>

>>VFP 7, Win2l
>>
>>I have several SQL select command that save data into a table, i.e.
>>

>>Select ...
>>         .
>>   FROM ...
>>   INTO TABLE name NOCONSOLE
>>

>>name is just an output name.
>>
>>This seems to create icons on my desktop. How do create the tables with out creating the icons. I am sure I am missing some thing obvious, but do not see it.
>>
>>TIA.