Hopefully I won't wear out my welcome here! I now need to export data into an xls spreadsheet template that has existing information in it. I am struggling with the ODBC to an XLS workbook. I can go to Access or another RBase database with no problem. I set up my file 'usage_request.xls' as a system DSN using the Microsoft XLS driver. I connect to the data source just fine, but when I try to attach to the tables (through the menu bar) I get an error (2045) Syntax is incorrect for the command Sconnect. It then prompts me to attach tables. I select my table 'Usage Request' (a workbook tab) and supply a valid alias name 'Usage_Req'. I get the same (2045) Error. I click OK and I get Error (2370) Row length exceeds maximum of 4096 characters. My table appears in the table listing. When I try to access the table I get an error [Microsoft][ODBC Driver manager] data source name not found and no default drive specified. What am I doing wrong......
....and yes I'm sure if Razzak responds...it will be a short answer that get me out of trouble and the....It's a simple as that or that's all there is to it...I'm spending way to much time in the forum!
