Re: beginners question : how to import textfiles into databases
>
> Here goes : how can I, using the dbimport tool get some tab-delimited
> text-file data into my database ? (the file comes over from PC access
> database)
OK. You wouldn't use dbimport, you would use either dbaccess with a LOAD
command or you would use dbload.
The bluntest way to do what you want (because that's the way I approach remote
support is:
1) vi your_raw_data_file
2) :1,$s/ /|/g
(where the spaces above are a TAB)
3) save the file.
4) dbaccess dbname
q
n
LOAD FROM your_raw_data_file INSERT INTO customer;[ESC]
r
HTH and good luck.
--
Ciao,
Billy
+------------------------------------------------------------------------------+
| Billy Wheeler Chief Cook and Bottlewasher The West Solutions Group |
+------------------------------------------------------------------------------+
| (E) billy@west.co.za (U) http://www.west.co.za/billy.html |
+------------------------------------------------------------------------------+
| Microsoft Word 6.0a to your mother .... |
+------------------------------------------------------------------------------+