How can I export a column of IDs from a table in Access into Word, and then seperate each ID by a comma? This data will then be plugged into Business Objects.
E.g.
123
1523
296
Into:
123,1523,296
In addition to this, if there are more than 1000 IDs, then they would be split into blocks in Word of 1000. Seperated by a space.
E.g.
123
1523
296
Into:
123,1523,296
In addition to this, if there are more than 1000 IDs, then they would be split into blocks in Word of 1000. Seperated by a space.