home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 10,837 of 10,840   
   Raoul Watson to Mojo   
   Re: XML or Access DB/ADO Import/Export??   
   24 Mar 11 22:47:36   
   
   XPost: alt.comp.lang.vb, comp.lang.basic.visual.misc   
   From: WatsonR@IntelligenCIA.com   
      
   On 3/24/2011 3:57 PM, Mojo wrote:   
   > Hi All   
   >   
   > As per a previous post that I've just done, to transfer data from one   
   > VB6/Access DB app to another I created XML export files so that I could   
   > export from one and then import into the other, but XML seems a really slow   
   > method when files are only in the 1MB-3MB filesize bracket.   
   >   
   > I'm just toying with the idea of exporting from one VB6/Access DB app to a   
   > cut-down access db and use this cut-down db as my export file to import into   
   > the other VB6/Access app - does this make sense?  Would this be the   
   > better/quicker way?   
   >   
   > Thanks   
   >   
   >   
   >   
   My XML knowledge is limited so I can't answer that part of the question.   
   The other part however I don't understand. Am I to understand that you   
   are exporting Access db records from one application to another?   
   I do all my db code in VB6 so I am not sure why you wouldn't just create   
   a db file, and export your records into it. In the other app or PC, read   
   the mdb file and simply put the records in the other app's database.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca