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.