>Hi!
>
>I have a Microsoft Access database that I need to extract data from one of the tables.
>The problem is that one of the fields is a character(250) - which in Foxpro is a memo field. How can one in code create a view and change the size of the field to character( 254). I don't mind changing the size of the specific field - but it needs to be text.
>
>Thanks
>
>Gary


It is not neccessary to be a Memo in VFP. In VFP you can create a Charachter field up to 254.About the other question I don't quite understed it. What you want to do? Just to select field in VFP or to update ACCESS Table structure? And why it is needed to be 254 chars?