Table to Table Import w/ different field names

[sdglenn]

Is there a utility or program that help one import data from an old database table to a new database table with different names"

 

[burrcm]

You can create your new table in design view by starting from scratch or by copying the structure from the old table and then modifying as needed, then using an append query to copy the data to the new table. The query lets you specify which columns receive the data.

Chris B