>>I set the PATH to a certain director, but the INTO TABLE test1 was created in my WINDOWS\DESKTOP directory. I can not specifically state the directory, because it is different on all my clients servers. Want to set the PATH with a SYS(16). How can i specify were i want the INTO TABLE to go?
>>
>>thanks
>>
>>brenda
>
>

---

Brenda,
>Just add your path as a prefix :
>

lcMyTestPath = "c:\myTest Files Directory\"
>select * from ... into table (lcMyTestPath+tcTablename)

Even UNC names would work.
>Cetin

---

More importantly, SET PATH changes the VFP search path - you need SET DEFAULT or CD to change that actual working directory.