Hi Martin,
Not much handy to .Net but yes with VFP you can.
And its very much possible by creating a dll in VFP,
Check help of VFP APPEND FROM
APPEND FROM FileName | ? [FIELDS FieldList] [FOR lExpression]
[[TYPE] [DELIMITED [WITH Delimiter | WITH BLANK | WITH TAB
| WITH CHARACTER Delimiter] | DIF | FW2 | MOD | PDOX | RPD |
SDF | SYLK | WK1 | WK3 | WKS | WR1 | WRK | CSV | XLS | XL5
[SHEET cSheetName] | XL8 [SHEET cSheetName]]] [AS nCodePage]
CURSORTOXML of VFP will provide you an XML file for .Net to pick up.
>Season's Greetings to one and all!!!
>
>Just would like to know how (if it is possible) to import a text file delimited with a pipe or vertical bar (|) into a DataTable. If this is not possible what would be the best way to retrieve the data and display it in a grid?
>
>Thanx! and MERRY CHRISTMAS to all DotNetters!!!
>
>Martin