[Westwales] Data Base Files
Robert Savage
bobsavage at uklinux.net
Sat Oct 2 14:34:21 BST 2004
On Saturday 02 Oct 2004 12:47, Gareth Bowker wrote:
>
> A common way of getting data in from a text file to a database of any
> description is to use CSV or TSV files, those are "Comma-separated
> Variables" and "Tab-separated Variables". If you can get the data in
> that format then most databases should be able to import it. Which
> database are you trying to import into?
>
> Gareth
Thanks Gareth,
Just spent some time trying to insert commas or tabs in the right places using
NoteTab (a much improved Notepad replacement), but concluded that it was
going to be a long job. I then saw sense, kicked out Microsoft's toy
software (Works), installed Lotus Approach and found that it would import
the text file after I defined the field sizes for it. Now have a .dbf file
as I required. :-)
Your answer was the "trigger" I needed many thanks.
Regards
Bob
More information about the Westwales
mailing list