Re: Transfering ascii text to a database table

->From: M23443@mwvm.mitre.org ->Subject: Transfering ascii text to a database table ->Date: Mon, 14 Jun 1993 15:09:29 GMT ->Reply-To: M23443@mwvm.mitre.org ->Organization: The MITRE Corporation, McLean VA 22102 -> -> I am attempting to transfer a text file to a database table, using the -> following command: ->load from "name" delimiter "\\t" insert into table_name ->It apparently doesn't like "name", yet I can't figure out any problem with ->the syntax, based on our manual. -> Any suggestions? Thanks in advance. -> ->Michael ->m23443@mwvm.mitre.org -> Your posting is a little too brief and too generic to make it easy, or maybe even possible, to diagnose your problem. However, here are a few things that you might check. If this checklist doesn't help you solve your problem, then a repost with more information would help us help you. 1. Are you using a fully qualified file path name, including extension, as "name"? 2. If you are not using a fully qualified path name, are you in the directory containing the file? 3. I have not used tab as a delimiter before. Sure, it should work, but ... Have you tried replacing the tabs with something else, perferably the default delimiter "|"? Since the delimiter clause immediately follows the file name, the command parser may be confused and be pointing to the wrong thing as causing the error. If you repost, please specify environment, and product version numbers, whether you are using DBAccess or I-SQL, etc. Other useful information might include: 1. Exact text of command, not a generalized version. 2. Exact text of error message. Lower priority: 3. (partial) directory listing, showing dir and file name of file you are trying to load. 4. Table definition, and first few lines of text file. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, Tech Ops | / \\ alan@den.mmc.com | P.O. Box 179, M/S 5422 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\