export database values

  • 15 years ago
    hi,

    i have a question about the best way to export part od access database do another  access database...
    databases have identical shema


    i have 3 datatables in it (table1 -> table2 -> table3)

    I nead to export data filtered by table2, so records in new database would be:

    table1        |table2    |table3
    -IDT1_1  
              -IDT2_1    
                               -all values linked to upper rows


    I was thinking to create new cloned dataset and fill it with filtered values. I filter values using dataview's

    another question:
    how can I copy all values in a dataview  to a dataset, so I don't have to read it row by row?

    thanx!

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.

“Anyone who considers arithmetic methods of producing random digits is, of course, in a state of sin.” - John von Neumann