Metin,

I'm puzzeld.

Lets see if I can ask the right questions
1) What version of VFP and what primary database?

2) The CA should deal with the data to make the import fit for the storage (Data types, integrity etc.))

2) The CA will on one hand read data from the text file and on the other hand write those data to place from 1)
3a) In wich way you generate PK's?

3) this is all work the CA should do

Agnes

>I know I can do it but I need to an updatable cursor with text file. I don't want to do export-import frequently...
>
>>Metin,
>>
>>so I guess you would like to import the file. And the result should be an cursor bound to a CA. A assumption is that we talk about native VFP databases.
>>
>>I will describe a "write only" CA. (you can not query a database with it)
>>
>>
>>One way would be to create a cursor with the appropriate fields eg
>>

>>CREATE CURSOR curImport (c1 c(n1), c2 c(n2),..., t1 Type, t2 Type ...)
>>

>> where cx is the number of the field in the import and ni the lenght of the field.
>>
>>t1 .. tn are representations for the targets of the imports.
>>
>>Provide the properties of the CA as needed (CURSORSCHEMA, TABLES, KEYFIELDS, etc), note that only the tn fields are bound to the target tables.
>>
>>Bound the cursor via CURSORATTACH to the CA
>>
>>Import the file via APPEND FROM filename TYPE SDF
>>
>>Now you have a cursor with all the information from the file. All is character in the c fields yet. t fields are empty.
>>Now you can transform each c field to the appropriate t field. You may do any needed validation here.
>>
>>A TABLEUPDATE should write to the target.
>>
>>
>>
>>You may also generate a CA with the CursorFill way. (Fill SELECTCMD and call Cursorfill with nodata parameter.)
>>Then you may generate the cursor mentioned above, do all the transformations and fill the CA from that cursor.
>>TABLEUPDATE.
>>
>>
>>Just keep in mind that a CA bound cursor is just an VFP cursor. The CA is just an object that holds all the things otherwise set via DBCSETPROP and some events for special table operations.
>>
>>
>>I personally, do not use CA's for such work. Normaly imports are a little bit to tricky to do them in normal operation. So I lock the DBC for a single user and use plain cursors.
>>
>>Hope that helps
>>AFK
>>
>>
>>Agnes
>>>>Hi Metin,
>>>>
>>>>it would be helpfull if you could provide what access you need. There is a range from reading filename to import the file
>>>>
>>>>Agnes
>>>>>Hi All,
>>>>>
>>>>>I need access a text file with cursor adapter class. I tried connection strings which I found from web but not success... :(
>>>
>>>Hi Agnes,
>>>
>>>That's a fixed lenght text file like:
>>>
>>>AAAAA00005555BBBBBB
>>>CCCCC00003556CCCCCC
>>>QREWW00432445GFDGDF