splitting memo field at character limit

[Montana_Trader]

I have a product database that includes a memo field for product
descriptions. That database must be imported into a legacy system that
has four text fields for product descriptions, each with a 250
character field length.

So, I am looking for a way to write a query or script that will pick up
the first 250 characters of the memo field and insert them into the
first field of my query, the second 250 characters into the second
field of the query, etc. until it reaches the 1000 characters. It
would also be nifty if it alerted me to which records have more than
1000 characters in the memo field, so that I could edit down the data
to a more manageable record size.

Any ideas?

[pietlinden]

use MID.

first one:
Mid$(MyTextField,1,250)
second
Mid$(MyTextfield,251,250)
third
Mid$(MyTextfield,501,250)
fourth
Mid$(MyTextfield,751,250)