Append Queries

  • Thread starter Thread starter Michael Stengel via AccessMonster.com
  • Start date Start date
M

Michael Stengel via AccessMonster.com

I currently have an older database with one (1) massive table all text
fields. Developed a new database using many tables and lookup. Problem is
appending data from old database to new one. Rejects for text fields trying
to update to the the new number (lookup) fields in the new tables. Anyone
know how to do this?
 
Use calculated fields in your append query to convert the text fields to
number fields. For example:

Number1: Val([Text1])

and so on.
 
Back
Top