How to export to excel from an ADP
Any one got an idea on how to get data from sql to excel or even a text file via an ADP project? I used to be able to use the transfertext function in a MDB but I keep getting a
error 3027 cannot update. Database or object is read-only.
File name isn't long. Error seems to be the same if I use a view, procedure or even a table.
Help appreciated. Cheers