Well with help from Sami and yourself, I have went a little further. I beleive they are foxpro files. I do have CDX files.
I was able to open with foxpro 5.0a. I exported in an xls format, but lose my memo columns. It looks like I will have to get the currency and number columns from foxpro by exporting to xls. Open with excel and save as cvs. Load into R:base as cvs and merge them with the table I am creating within R:Base using ODBC to connect to the original files I am trying to export. Can't figure out a simpler way. Steve -----Original Message----- From: MikeB [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 3:18 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - RE: SATTACH Yes. DBT is a memo table. To further clarify which DBase compatible file you have, go to http://www.wotsit.org/search.asp?s=database and see if the DBF info is any help to you. If I could remember which is which on the index file naming, it would help. But If there are any *.idx files, then it is DBase. *.CDX is FoxPro and I think *.NTX is Clipper. ----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 2:51 PM 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 > > > > > > > > > >
