Hi, thanks for your reply. Yes I did use the wizard, and it wasn't able to seperate the field names and the data.

When I open the csv file on my desktop, it loads up in excell there are like 5 field names, then the data below, then spaces below that, then another row of field names, then under that more data.

Is there a way to be able to get all the field names in one row then the data underneath.

Any ideas?
many thanks in advance, Mark

---

Reply from Alex Hedley:

You'd need the data to be in a tabular format so you might need to change the method you export it to, it sounds like it's more of a page by page report instead of a table.
If you don't have any other options you will have to clean it up first, some macros/vba might be possible to automate removing extra lines etc