Steve, When you use the SCONNECT you are opening the data source. With FoxPro you will be given a list of the available tables after the SCONNECT. You can select the tables from the list or you can use the SATTACH tablename command for each individual table. Depending on the naming conventions of the tables and columns you might have to use the SET ANSI OFF command to be able to attach to tables that have SQL reserved words in their structure.
Steve Vellella "Fogelson, Steve" wrote: > 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/
