K
Kenneth Brody
I am trying to create a .XLS file via ODBC and it's not working. If I
use the same code with a different DSN (such as a dBase or Access file)
it works just fine.
Unfortunately, I don't have the exact error message, but as I recall,
executing a CREATE TABLE statement returns an error message stating
(paraphrasing) "can't do this on a read-only table". The .XLS file
does not get created and, naturally, the table within it does not get
created.
Does the Excel ODBC driver support any file manipulation, or is it
strictly a read-only data source?
If necessary, I can get the exact SQL statement and error message text.
use the same code with a different DSN (such as a dBase or Access file)
it works just fine.
Unfortunately, I don't have the exact error message, but as I recall,
executing a CREATE TABLE statement returns an error message stating
(paraphrasing) "can't do this on a read-only table". The .XLS file
does not get created and, naturally, the table within it does not get
created.
Does the Excel ODBC driver support any file manipulation, or is it
strictly a read-only data source?
If necessary, I can get the exact SQL statement and error message text.