Loading a table from a flat file.

[dquintard]

Hello all
I am using version 6.5.
I want to load a newly created table from a flat file, however from what I understand the LOAD statement only loads from a device.
Is this true?
I need the correct syntax to load a newly created table from a flat file.
THANKS IN ADVANCE!!!

 

[JohnDTampaBay]

Check BOL for BCP and BULK INSERT. That should at least point you in the right direction. --Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[Vinodk]

DTS is another option you would like to try ...

HTH,
Vinod Kumar