Hi Barne,

>New to Universal Thread and a beginner @ VFP, ver 7.0. I have several questions:

Welcome to UT!

>1. Is there any way to invoke the File Import Wizard from within a compiled application?
Yes, you can call it in your application this way

DO wzimport.app

>2. I have tried the Import command and it won’t import without specifying a database. Can you import just to a free table? Also, the following command does not create a table “test” from the Excel Worksheet “imscc”: IMPORT FROM imscc DATABASE t NAME test TYPE xls. Instead imscc is converted into a table and there is no test.dbf? What’s happening?

The IMPORT command doesn't required DATABASE clause. Anyway FoxPro always creates table with the same name as XLS file it imports.

>3. The discussion of when to use the &cvar and when to use the (cvar) is unclear. The REPLACE WITH command seems only to accept the “&”. Is this correct, or am I doing something wrong? When trying to replace the value of a field in one table with the value in another, I have had to first assign the name of the field to a cvar1 in the 1st table and cvar2 to the desired field in the 2nd, then use the & symbol as follows:
>REPLACE &cvar1 WITH B.&cvar2. Is this the correct procedure, or is there a simpler way?

I'm not sure what the problem is in this case and why you need macro substitution or Name expression. In general if names of the fields ar known, the REPLACE command may look this way

REPLACE field1 WITH table2.field7 IN table1

It's also better to post unrelated questions in the separate threads so it'll be easier to answer and follow discussion.