Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Sat Sep 22, 2018 2:21 pm
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Copying from one access database to another
PostPosted: Thu Oct 27, 2005 11:08 am 
Offline

Joined: Sun Oct 09, 2005 8:02 pm
Posts: 9
I have an access database that I would like to copy certain fields from into my database I am using in my realbasic project. Question is, how can I do this easily?


Thanks,

Charles


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Thu Oct 27, 2005 12:30 pm 
Offline

Joined: Sat Oct 01, 2005 5:19 pm
Posts: 3216
Open the Access database and your database at the same time

Make a recordset of the information you want from the Access database

loop through the recordset one record at a time, and put the data into your database using a databaserecord

close the Access database


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Thu Oct 27, 2005 12:45 pm 
Offline

Joined: Sun Oct 09, 2005 8:02 pm
Posts: 9
Is there some sort of tutorial I can look at that shows exactly what to do?


Thanks


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Thu Oct 27, 2005 1:07 pm 
Offline

Joined: Sat Oct 01, 2005 5:19 pm
Posts: 3216
I doubt it, that's a very specific thing you want to do. Just get your hands dirty and get started.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group