New topic in General: Transfer Access tables to rsd
Paul Burnside - Wed Apr 30, 2008 11:07 am <http://forums.realsoftware.com/viewtopic.php?t=22135> I'm sure my question will be a matter of personal taste but I'd be interested in any responses. I'm currently building a RealBasic database application originally done with MS Access. I'll need to transfer existing Access tables to a RealBasic RealSQLDatabase. The Access backend consist of numerous ( related ) tables. My question is - would it be easier to export the Access tables to an Excell spreadsheet ( one sheet per table ), rearrange the columns as needed for the RB application then write code to import the Excell sheets into RB tables as needed .........or would it be easier to write code in RB to import the Access tables directly into the RB application and handle the house-keeping from there. I hope I worded all of the above clearly enough. Looking forward to your responses. Paul RB 2007r5 on Windows Vista -- Over 900 classes with 18000 functions in one REALbasic plug-in. The Monkeybread Software Realbasic Plugin v8.1. <http://www.monkeybreadsoftware.de/realbasic/plugins.shtml> [email protected]
