General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>Hi Michielle,
>>>
>>>>I have a large text file that I need to turn into a dbf. The "fields" are a fixed length, but there are extra spaces so it's not strictly delimited. Is there a way to import this into a dbf where the fields are already set using the lengths of the fields to determine what text goes in which field?
>>>
>>>What does the text look like? Could this be a SDF file?
>>>
>>>Christof
>>
>>I'm currently trying it as a SDF file, but in case that doesn't work, I'm looking to see if there's a better way that I missed.
>>
>>There's 792,502 records in this file. Is there a way to append only a few of the records for testing purposes?
>
>The easiest thing to do would be to open the file with an editor and simply copy a small number of records into another file without reformatting, and then play with the copy that contains the few records you copied.
Yeah, that would have been a good idea if I had seen it before I got it to work. :)
Thanks,
-Michelle
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only