SELECT 0 before the import solved the problem. The table created during the import was replacing the cworkarea table.


>I'm importing data from Excel using a modal child form and that works fine but I need to put the imported data into a table and that's not working. I open the form using:
>
> oDialog = .Openmodalchild('importa1',1)
> zzcancel = m.oDialog.SHOW()
>
>The primary data table for the parent form is called COMPANY. It’s opened several times and one alias is COMPANY1 which is the name used in the New method of the parent form.
>
>I try to create a new record from the modal child form using the following code in a command button:
>
> THISFORM.ocaller.new('COMPANY1')
>
>An error is generated in the New method of the parent form that says COMPANY1 does not exist. If I try to Select COMPANY1 in the child form I get the same error but don’t get an error when I Select COMPANY in the child form. Can I not call the New method of a parent form from a modal child form? Can someone tell me what I’m doing wrong?