Re: beginners question : how to import textfiles into databases

Hi, dbimport is meant for creating the database,tables and loading the data into the tables. But the sql file and data files should have come from dbexport. In your case you have a data file which you got from access database. First you have to create the table with same no of columns. (i.e. what ever no of columns you havae in the data file). Ofcourse the data types also should match. Then you can get into dbaccess session and 'load from <data file name> insert into <table name>' This should work. If you have any problem, please feel free to send a e-mail. Thanks & Regards, Srinivas On Tue, 6 Aug 1996, jeroen clarysse wrote: } Sorry for this really stupid question, but we haven't got the manuals yet } (the machine is only on trial. Once the decision to buy it has been made } (which will surely happen, only I don't know when (I'm the one working } with it, so I have no say in purchase decisions ;-)) we'll get the paper } truck... until then this newsgroup is my only resort } } 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) } } all I get is } } $ dbimport } Usage: } dbimport <database> [-X] [-c] [-q] [-d <dbspace>] } [-l [{ buffered | <log-file> }] [-ansi]] } [{ -i <dir> | -t <tapedev> [ -b <blksz> -s <tapesz> ] [-f <script-file>] }] } NOTE: <log-file> must be a complete path } arguments to dbimport are order independent } } and when trying harder : } } } $ dbimport customer } Cannot open sql script file } } } anyone a suggestion for me ? } } thanks } jeroen } } jeroen@hypervision.be }