Infile statement to import a specific worksheet

[sks521]

Hi folks,

How do I use infile statement to bring in data from a worksheet please?

Thanks

[ballardw · Accepted solution]

---

@sks521 wrote:

Hi folks,

How do I use infile statement to bring in data from a worksheet please?

Thanks

---

Actually INFILE is not intended to work with spreadsheets. It is intended to read text files either fixed column, delimited, named input or some combination thereof.

If you want control over how data is read then export your worksheet (File > SaveAs) to a CSV file and use an infile statement pointing to that file to read.