How to import txt file content to a single Calc cell?

I want to import the content of several txt files, each one into a different single cell, in the following way:

  • first column: txt files paths
  • second column: txt files contents

txt files are named with numbers (1.txt, 2.txt, etc).

I’ve tried with DDE, but it displays each line of text in a different row, and I need the whole txt file in a single cell.

Does anyone have any idea how to do it?