Razzak,
Thank you. I can now see the table structure of the Acess database. Jan From: "A. Razzak Memon" <[email protected]> To: [email protected] Date: Thu, 09 May 2019 20:05:08 -0400 Subject: Re: [RBASE-L] - SCONNECT and SATTACH Jan, The best approach to understand and view the external (other) database structure, is to use the Database Explorer's Utilities option. 01. Start RBGXE or RBGX5E and CONNect to R:BASE database. 02. Database Explorer > Main Menu > Utilities > Connect SQL Data Source ... Once connected successfully ... 03. Database Explorer > Main Menu > Utilities > Attach SQL Database Tables This is where you will see the list of all tables and views While SATTACHing, you will have the option to attach that table as: . Attach As Alias . Attach As Temporary . Attach USING ALL Once SATTACHed successfully, you can review everything and then write a command file to accomplish the exact same task automatically. That's all there is to it! To further understand and automate the entire process, take a close look at the R:BASE Super Advanced Training Sample Applications (Part 5): Application: R:BASE for Everyone (Integrating R:BASE X.5 Enterprise (Version 10.5) with ODBC Compliant Databases) Have fun! Razzak At 05:57 PM 5/9/2019, jan johansen wrote: >Group, > >I haven't really had the need to utilize these commands until now. >I need to connect to an Access DB (mdb). > >I can SCONNECT to it no problem. >However how to SATTACH to the internal tables if you have no idea what >the Access structure is or what the table names are? -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/201905100005.x4A05CjA002697%40atl4mhob12.registeredsite.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20190510141429.830086%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
