I am importing a ton of data from Excel into Access. It is working quite seamlessly, until I have encountered 9 digit and foreign postal codes. Then it wants to change the type to number instead of text and will only import the 5 digit codes. Is there a way to use a query to automatically update those fields that are left empty after the import once I change the type back to text?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I use a query to add data not imported once I change data type
- Thread starter elfudge35
- Start date
- Status
Similar threads
- Locked
- Question
- Question