>Hi guys, just a quick question that has me brain-dead at the moment.
>
>I'm scanning (using SCAN and ENDSCAN) a reference table that contains info that I use to build a filename. Inside the scan loop, after building the next filename obtained, I issue an IMPORT command (standard stuff from an Excel spreadsheet). My problem is this: The import command itself, once completed, kills the workspace I was performing the scan in orginally.
>
>I'm I afflicted today, or has anyone else ran into this? (I may later look at it and catch the problem, but so far it has me bewildered!)
>

Yep - change to a different data area (SELECT 0) and then issue the IMPORT command. When the IMPORT finishes, switch back to the table being scanned.