Can I replace Table in my Access Data Base ??

[Will]

I have several tables in my Access database.

If I export one of the tables so that it can be updated as a seperate
project... (add records)

When we get done can I import the updated table back into the original data
base and have it replace the original, older table?

Will my Queries, Forms, etc still work?

What if we add a few fields to the table while it is exported? If the
original fields are still there and still have the same names, etc, will the
original queries and forms still work after we re-import the table on top of
the old one?

thanks for any help.

Will

 

[Guest]

Will:

Yes, though you would want to truncate the table, before importing.

Yes.

For this scenario, I would suggest adding the new columns, to the existing
table. Truncating the data, then importing the new data. This will allow
you to keep any relationships.

Good luck.

Sharkbyte

 

[Will]

Sharkbyte,

I know what truncate means but I'm not sure what you mean by "truncate the
table" or "Truncating the Data"

Can you give me more of an explination?

thanks for your help.

Will

 

[Guest]

Sorry. Truncating a table would simply be removing all of the data but
leaving the table structure intact.

Sharkbyte