H
Hexman
Yes, you can tell I'm an Access newbie.
I started developing an app in vb using an access database. While the
users were accumulating data in the first app, I proceed in
development of the app. I have added columns to the database
structure in my development db. Now its time to get the data from the
initial db the users have been updating.
I thought an import would add the data for matching column names and
use defaults for the others. I was wrong (or I didn't look deep
enough into it.).
In other systems I have worked on there were utilities that would
allow you to map fields from one table to another.
Its probably pretty simple once you know where to look, but I don't.
Please help me out.
Hexman.
P.S. All fields in the original table have not had any ot their
properties changed in the new table, including PKs.
I started developing an app in vb using an access database. While the
users were accumulating data in the first app, I proceed in
development of the app. I have added columns to the database
structure in my development db. Now its time to get the data from the
initial db the users have been updating.
I thought an import would add the data for matching column names and
use defaults for the others. I was wrong (or I didn't look deep
enough into it.).
In other systems I have worked on there were utilities that would
allow you to map fields from one table to another.
Its probably pretty simple once you know where to look, but I don't.
Please help me out.
Hexman.
P.S. All fields in the original table have not had any ot their
properties changed in the new table, including PKs.