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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append query 1
append queries 1
Append Query Issue 0
Append Additional Data Into New Database 12
Append to two different tables 23
How to append query w/lookup fields.... 2
Numeric Field Overflow Error 5
Append New Record Via A Form? 1

Back
Top