H i Chuck
I am not sure about
MS XLS driver but I have built MS SQL data bases and accessed with R:BASE. Your
problem I think is data types. The table you are trying to attached to has
columns that R:BASE does not understand.
In MS SQL server
the data type. Its been sometime since I did this now. From memory CHAR is no
good, while Varchar (25) is okay R:Base see as note 25. Datatype DateTime is okay.
Real is okay. Numeric in SQL is a problem for R:BASE . I think memo fields
are a no go as well.
Suggest you create
a test table in MS SQL or MS XLS and check out what R:BASE will
interpretate.
Regards
Victor
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, 22 March 2005 6:19 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Sattach to xls workbook
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, 22 March 2005 6:19 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Sattach to xls workbook
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!
