XML or Access DB/ADO Import/Export??

[Mojo]

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

[Helmut_Meukel]

Post by Mojo
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?

Hmm,

as far as you told us about your problem, I can't see why you would
export data to a file and then import from this file.
Do you physically store this file on an external drive, USB stick, ...
and then carry it to another pc to import the data there?

If this isn't the case, why not just open both databases and transfer
the data directly?
You can do this by VB6 code, or create a SQL query to transfer the data.

I used SQL queries in my VB6 code to transfer at midnight all new or
updated records into a backup db on another pc on the LAN.

Helmut.

[Raoul Watson]

Post by Mojo
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.