On Tue, 17 Aug 2004 16:08:28 -0700,
wrote:
I am creating a table using access and already have a data
table. I want to create a new one with new data and a
different name for the table.
How can that be done?
Short answer: with a MakeTable query based on the original data table.
Longer answer: Ordinarily this should NOT be a routine operation! In a
properly normalized database, you would usually have a set of defined
tables containing all your data; you would use Queries to select,
sort, filter and manage the data; Forms to display the data from the
queries; and Reports to print that data. Only once in a blue moon is
it appropriate to have two tables with data of the same "shape";
storing data in tablenames is ALWAYS a bad idea.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public