New topic: Copy data from MS Access to REALSQLDatabase
<http://forums.realsoftware.com/viewtopic.php?t=29658> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message kweding Post subject: Copy data from MS Access to REALSQLDatabasePosted: Thu Aug 20, 2009 2:17 pm Joined: Thu Aug 20, 2009 2:07 pm Posts: 1 Being a Windows developer for ages, I am slowly migrating to Mac... A couple of years ago I developed an VB.NET application where I stored the data in a MS Access Database. Now I am porting this application to Mac using REALBasic and REALSQLDatabase. But I do not want to enter all thousands of records in my database manually using my application. Is there any simple way to copy and paste from Windows' MS Access to Mac's REALSQLDatabase? Or do I have to develop a simple application (using datagrids) to enter the data? Top dglass Post subject: Re: Copy data from MS Access to REALSQLDatabasePosted: Thu Aug 20, 2009 2:25 pm Joined: Fri Sep 30, 2005 9:29 am Posts: 568 Location: California Export the data from the Access tables (tab-delimited would be OK probably), import the data into your database using either a DB manager application or via an import routine you write. That's probably going to be simpler than trying to connect to the Access DB via ODBC and copying the data directly. Top Steve Garman Post subject: Re: Copy data from MS Access to REALSQLDatabasePosted: Thu Aug 20, 2009 2:30 pm Joined: Fri Sep 30, 2005 3:53 pm Posts: 2925 Location: England I'd recommend writing a simple RB app using ODBC to read from Access and writing directly to your REALSQLDatabase. I see no need for grids. But on the subject of datagrids, have you identified a control you intend to use for data entry? If not, you might want to look around at what's available. Most people seem to settle for Einhugur's Stylegrid. Edit: dglass may well be right about exporting the data instead. _________________ Steve Garman Using REALbasic 2008r2 Professional on Windows Vista Ultimate and REALbasic 2009r3 Professional on Linux Ubuntu 9.04 Desktop Occasional blog Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
