We have various short text files that we need to use to update some of our tables.
For example, our off-site office sent us their terms in a text/ASCII file. Its contents:
01 1% 6 N/30
02 2%/20 N/30
03 2 % 20 DAYS NET 40
04 2 % 30 DAYS
We have a table we need to update it with that data.
How can we embed an import or reading of an ASCII file with an UPDATE command?