Steve - I haven't done it in a long time - so I hope some other lurker will jump in if my answer is not correct - but I believe that when you connect to the FoxPro database, it will look much like R:BASE does - one database with each table listed. So, to answer your question, you would SCONNECT to the database and then SATTACH each table.
For kicks, try it using the R:BASE menus instead of using straight R:BASE commands - it's interesting what you can learn! If you haven't ever done it that way - follow these steps: 1. Set up the FoxPro database as an ODBC source 2. Go into R:BASE and connect to your database (or a test database) 3. From the R:BASE main menus, choose Utilities/Connect SQL Datasource 4. Pick your FoxPro database 5. From the R>, go to the Utilities menu again and choose Attach SQL Database Tables 6. You will see the list of tables and views - and you have options to attach the table/view as alias (in case you already have a table with the same name in your database). Click on one table or view and choose attach - and continue to attach each table from this screen. This is the same process as issuing the SATTACH statement once for each table - except from the command line you can also alias the column names if you need to: SATTACH tblname AS tablealias USING collist ALIAS aliaslist Sami ----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 4:14 PM Subject: RE: Record Transfer > Thanks Sami. > > One more Question. Do I SCONNECT to each FoxPro file individually one at a > time? > > Thanks > > Steve > > -----Original Message----- > From: Sami Aaron [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 4:04 PM > To: [EMAIL PROTECTED] > Subject: Re: Record Transfer > > > Steve - > > There should be a FoxPro ODBC driver installed on your Windows computer. I > would set the FoxPro database up as an ODBC datasource and do an SCONNECT > statement from your R:BASE database. Then do your PROJECT or APPEND or > INSERT statements as needed. > > The multiple FoxPro files include indexes and memo fields - but the ODBC > connection should handle all of that for you. > > Sami > > ----------------------------------------------------------- > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > 913-915-1971 > http://www.softwaremgmt.com > > ----- Original Message ----- > From: "Fogelson, Steve" <[EMAIL PROTECTED]> > To: "R:Base User Group (E-mail)" <[EMAIL PROTECTED]> > Sent: Wednesday, September 25, 2002 2:44 PM > Subject: Record Transfer > > > > Never done this before. I need to move records from FoxPro database files > > over to a R:Base application. > > > > Is there a way to do this? > > > > Also there is a couple of FoxPro files for every table. Any special > > considerations for that? > > > > Thanks for the help. > > > > Steve Fogelson > > Internet Commerce Solutions > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
