Are you aware that the upgrade to deal with access 2 and the year two thousand had a bug in the early upgrade, See the Microsoft site for the later patch.
I have experience exactly this problem.
I believe that you would be better to append the records using the mid() command on the data in a query update <br><br>i.e the first column would be mid([Field Name],1,6) if the field started at position 1 and finished at position 6. Repeat for each field
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.