How to export to excel from an ADP

JJ · June 6th, 2003, 09:29 AM

HI All,

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.

Error.

File name isn't long. Error seems to be the same if I use a view, procedure or even a table.

Help appreciated. Cheers
John

KenSchaefer · June 9th, 2003, 10:58 PM

Where is the code you are using?
And, for whatever file you are trying to update, are the underlying NTFS permissions OK?

www.adOpenStatic.com

Steven · June 13th, 2003, 07:25 AM

There's another option you could try - connect Excel directly - you don't really need the ADP as far as I can tell.
Just open up Excel, and go Data>Import External Data>New Database Query
This will allow you to connect Excel to any ODBC data source, and run a query that returns to Excel

Or am I missing something here?

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends