SQL Loader
From: Jon Griffin <nospam_at_e88.org>
Date: Sun, 13 Feb 2000 06:55:03 GMT
Message-ID: <bzsp4.566$m35.14588_at_typhoon.we.mediaone.net>
[Quoted] Is there a way to selectivly import fields from a CSV type file. For example if the csv file has the following agency,agency_name,first_name,last_name.... I want to import to 2 normalized tables: agency
agent
Date: Sun, 13 Feb 2000 06:55:03 GMT
Message-ID: <bzsp4.566$m35.14588_at_typhoon.we.mediaone.net>
[Quoted] Is there a way to selectivly import fields from a CSV type file. For example if the csv file has the following agency,agency_name,first_name,last_name.... I want to import to 2 normalized tables: agency
agent
agent needs fields 1(agency), 3,4 .....
agency needs fields 1 and 2 only
I tried adding position(1) etc and get junk. Is it only possible to use position with fixed length records? Received on Sun Feb 13 2000 - 07:55:03 CET