Subject | Importing via EXTERNAL file |
---|---|
Author | Peter |
Post date | 2004-10-28T00:51:27Z |
Hi
If I use the "external" option to import a fixed length fields text
file, what happens to the data when it is assimilated into the
database?
I believe that the "numeric" values will be converted to suit the
column format into which they are imported.
Does text remain as fixed length text strings?
If so how could the text be trimmed? (I am not very familiar with sql-
yet!)
Regards
Peter
If I use the "external" option to import a fixed length fields text
file, what happens to the data when it is assimilated into the
database?
I believe that the "numeric" values will be converted to suit the
column format into which they are imported.
Does text remain as fixed length text strings?
If so how could the text be trimmed? (I am not very familiar with sql-
yet!)
Regards
Peter