How do I create a flat text file from various fields within a table from a single database and adding some static information to the result as well? To clarify:
Let’s say the database name is User, which has a table called Properties. The table has three columns: Name, EmployeIDnumber, Status.
I would like to grab the data from each row (and continue to the end) and string the result into a flat text file while adding some static information.
Name | EmployeeIDnumber | Status
Joel | 3456 | Vacation
Bob | 4566 | Paid Leave
Amy | 7896 | Active Duty
The resulting text file needs to look like:
Joel, 3456, is currently on Vacation.
Bob, 4566, is currently on Paid Leave.
Amy, 7896, is currently on Active Duty.
Last row of table.