copying tables

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

Guest

I am just finishing work on an Access database that gets some of its
information from a data service. The supplied data comes in the form of a
tables only .mdb file that is download ed and unzipped. In developing the
database I manually imported the tables I needed and renamed them to fit my
naming scheme, thinking that it would be easy to automate the process later.
Later has come and automatiing the transfer is not as easy as I had hoped.

Is there any way to automate replacing the data in my tables with the data
from the source tables? Some of the tables have a fixed number of records
but some do not. There is no change to table structure or column naming.
Thanks for any suggestions or advice.

Phil Raidt
 
Phil

I didn't see any mention of whether the incoming tables have a consistent
naming convention...

One approach might be to link to the supplied data .mdb file/tables, rather
than importing them. You could also use "normalizing queries" against the
input to fill your more permanent (and hopefully well-normalized) tables.

Just because someone sends data in an .mdb table doesn't mean the data is
well-normalized...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Phil

If you are asking whether you could modify the table names in your "source"
data before importing or linking to it, yes.

That said, you may still want to consider reviewing the normalization of the
data you are receiving, and the data structure of your database. You could
still use append queries to add entire records, or portions thereof, from
the input data into your final data structure.

By the way, are you quite confident that you and I are using the same
definition for "normalized"?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top