Access Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?

Thanks,

Cindy
 
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?
Click to expand...

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.
 
Back
Top