>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