Hi Dave

Figued as much. Thought there might be a way to do it with a cursor adapter or a DSN but had no luck figuring that one out either.

I've just had another look inside the CSV and you are right, sometimes the field has quotes and sometimes not, depending on whether the text has a comma in it or not. Very messy. They are going to change the file to XML format later this year so I think I'll just accept the limitation and resulting truncation which doesn't happen often, for the moment.

Regards
Geoff Scott

>Geoff
>
>Natively it won't support anything that exceeds field size limitations nor will it handle memo fields.
>
>One fast way if Excel is available is to APPEND FROM to get all the non-memo fields, then open the file in Excel via automation and read the memo cells to pull the data into the cursor.
>
>Reading the file line my line involves some fairly complex parsing to deal with commas that may appear inside a quoted field.
>
>>I have an import file which is in CSV format. It has an alpha field which can be up to 2000 bytes long.
>>
>>I thought to use APPEND to bring the data into memo a field (along with the other fields.)If I try to import it using either DELIMITED or CSV my field gets skipped if it is defined a MEMO.
>>
>>Is there a way around this short of treating the entire file as one string and processing each line?