Steve If this a one time shot you may want to try using the ODBC to import the data to EXCEL. Rename the columns to meet R:Base rules.
Next highlight all the data including the column names. Save what you have hightligted as DBF4 (DBFName.DBF) in the same folder as YourDataBase. CONN YourDataBase ATTACH DBFName PROJECT NewTable FROM DBFName USI ALL DETACH DBFName Hope this helps Buddy -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 3:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SATTACH Sami, Thanks for the response. I used the following command: ATTACH st_products.dbf and I get the error -ERROR- Unable to open file : st_products.DBT (2583) I was able to get one file open with ATTACH st_optionval but when I try to project to another table using PROJECT s_optionval FROM st_ooptionval USING * I get the following error: -ERROR- Cannot find dBASE file in current directory or path (2585) Any thoughts Thanks Steve -----Original Message----- From: Sami Aaron [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 2:36 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - RE: SATTACH Steve - Try using just the ATTACH command rather than the SATTACH. It will link to a dbf table and may work better than the SQL attach. Sami ----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 1:35 PM Subject: [RBASE-L] - RE: SATTACH > I forgot to add that the Number column is defined with a length of 16. I > have other columns assigned with a length of 10 that work fine. > > Thanks > > Steve > > -----Original Message----- > From: Fogelson, Steve [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 1:33 PM > To: [EMAIL PROTECTED] > Subject: [RBASE-L] - SATTACH > > > Rbase 6.5+ > > I am trying to attach to a Dbase (dbf) table that has a column that is > defined as "Number" and one that is defined as "Currency". > > I get "-WARNING - Unsupported datatype for column XXXXX in table XXXXX > (2626)" > > Is there a workaround for this? > > Steve Fogelson > Internet Commerce Solutions > > > >
