two databases

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

Guest

I have to databases that are different in that one has only 1 more column of
data than the other.

I want to import the database that has the extra column into the one that
does not have that column.

I did not add an empty column or anything to the "lesser" database prior to
attempting an import. But it gives me an errorlog that seems to be full of
fields that are empty. Upon attempting the import it also doesn't let me
overwrite the table that the data appears in. I have to save it as a
seperate table.

Any starting points as to how an import has to be accomplished with two
databases with differing number of columns?
 
databases don't have columns, tables do. if you mean that you have two
databases that have an identical *table*, except that the table in one db
has a column that is not included in the table in the other db, then i'd
import the data the quick way:

link the "extra column" table into the "lesser" database. create an Append
query to dump the records from the "extra column" table into the other
table, and do not include that extra column in the query.

since you mentioned being unable to overwrite the table in the "lesser"
database, i assume that you want any data already in that table to be
eliminated and replaced by the appended data. so just write a Delete query
to remove all records from that table, and run it before you run the Append
query.

hth
 
Back
Top