data export - URGENT

  • 14 years ago

    I'm creating an application which will export selected data from one access database to another.


    if I have 2 tables in first database:
    Table1 (Id_T1, Country)


    Table2(IdT2, IdT1, City)


    what is the best way to export data filtered by table1 (Country) to second database.
    second database is identical like first database?


    So, If I select Germany in first table, I would like to export all Cityes from Germany to second database when I press button.


    I was thinking to create temp table and go trough all records (ex. Cityes in Germany) and write then in temp table. and then insert all data from temp table to second database.


    is there a better way?





Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer is a stupid machine with the ability to do incredibly smart things, while computer programmers are smart people with the ability to do incredibly stupid things. They are, in short, a perfect match” - Bill Bryson