>>I have some enormous files (300 to 700 meg) I manually bring into VFP. I copy an empty dbf and use the import wizard to import this data. They take about 1 hour to hour and half and are SDF. Is there a faster way to bring them in? I mean I would like these to import much quicker and am open to changing the format that fox is presented with. Any Ideas?
>>
>>We use these for queries, and play lots of (pull my hair out), what if games with them.

---

The primary difference between a Dbf and an SDF Text file, is the header, the byte (per record) used to indicate deletion status, and the SDF might have CRLF to indicate new records.
>
>In the past I think I've pulled fixed length records into a Dbf that do not have CRLF - so:
>
>I'm not really sure what the ascii code of the deleted byte is, but if you have any control over the structure of the text file, could you have an extra byte added that would appear in the deleted byte spot and ditch the CRLF's?
>
>Then all you would have to add is the header, using low level file I/O. Fabricating the header of course requires that you know how many records will end up in the resulting table. And then, change the extension to Dbf.
>
>I've never done anything like the above - so it could all be complete tosh. Just an idea.

Very interesting idea, Houston. Would be great, if somebody would implement it (no, not me :)) Dragan, are you lurking? :)