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