Append Queries

  • Thread starter Michael Stengel via AccessMonster.com
  • 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?
 
K

Ken Snell [MVP]

Use calculated fields in your append query to convert the text fields to
number fields. For example:

Number1: Val([Text1])

and so on.
 
Top