Steve, do you have the option to export your FoxPro files to dBase IV? RBase can ATTACH dBase files just fine. You may have some naming conflicts, but they are easily resolved during the import.
"Fogelson, Steve" <[EMAIL PROTECTED]> wrote: >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 >> > >> > >> > >> > >> >> > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
