Chuck,
What version of Excel are you using? On my XP Pro machine, the standard supplied MicroSoft driver supports only 2000, not 2003. You may have to load an updated driver for the 2003 version. When creating your ODBC source in the ODBC manager, there is a small drop down window where you select the Excel version. Insure that this is set to the correct version or it will not work properly.
-Bob
-------------- Original message --------------
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!
