OOPS...

the third line in the first code block should read

COPY STRUCTURE TO <b>E:\Payroll\HldXFer_Tbl</b> DATABASE E:\Payroll\Payroll

Also, be advised that the table and field properties are *not* copied to the target database.

Sorry 'bout that (sheepish grin)...


>Hi Nick,
>
>Try this:
>
>

>USE HldXFer_Tbl IN 0 ALIAS OldTable
>SELECT OldTable
>COPY STRUCTURE TO HldXFer_Tbl DATABASE E:\Payroll\Payroll
>USE IN OldTable
>

>
>Add the WITH CDX clause if you have indexes.
>
>If it has data, then you can:
>
>

>USE HldXFer_Tbl IN 0 ALIAS OldTable
>USE E:\Payroll\Payroll\HldXFer_Tbl IN 0 ALIAS NewTable
>SELECT NewTable
>APPEND FROM OldTable
>USE IN NewTable
>USE IN OldTable
>

>
>to copy the data from the old table to the new one.
>
>HTH
>
>>I am trying to find way to copy an existing table (has no indexs, no data) to another program with the same name. For example I have a payroll.dbc with a table call hldxfer_tbl on my network drive in a folder called payroll. I want to copy this table to my e: drive that also has a payroll.dbc in folder call payroll. I tried to copy the table in explorer but it said that the table belongs to different dbc. How do you get an identical table from one dbc to another?
>>
>>THanks
>>Nick