keepingbusy
Programmer
We are trying to convert an Access table to a VFP9 application.
We have exported the Access table to a CSV (with , delimiter) file which then allowed us to import it and create a table structure via VFP.
So now we have the table structure in a VFP9 table that matches the Access table structure, the "Raw" data we expect to import into the new VFP table will be a TAB delimited type txt file or may have a csv extension (this is not an issue as we can rename it etc)
When we try and import a txt file into the VFP9 table that would normally be imported into the Access table, only the first field is populated.
The code to import we are using is:
Code:
Use OurTable
APPEND FROM testfile.txt DELIMITED WITH CHAR TAB
If I can post any additional information that would assist, please let me know.
Thank you
Lee