Appending data using coding..!!

[desiretolearn]

Hi All,



Am new to VBA programming. I have a requirement wherin i need to transfer data from two tables in MS-Access to other table in same DB.
For Ex:

i have created 3 tables say A B and C, i need to take data from A and B with some criterias and put it in table C.

Please guys help me out.

Thanks in Advance..

[JoeM]

Sounds like you want to use an Append Query. See: http://office.microsoft.com/en-us/ac...010076526.aspx
If you do a Google Search on "Access Append Query", you will find many other links and even YouTube tutorials.

Also note, you may want to consider if you even really need to do that at all. In many instances, if you can get what you need through a query, there is often no reason to physically write the data back to a data table, especially considering Queries can be used as the Data Source for other Queries, Forms, Reports, and Exports.

[IslandHydro]

For each transfer (A to C, B to C) I'd probably build a SQL string such as this:

Dim SQL as String
SQL = "INSERT INTO TableC (FieldA, FieldB) Select TableA.FieldA, TableA.FieldB from tableA Where FieldC = X"

you can actually build the Query in the query builder, then switch to SQL view to see what it should look like. Then transfer the SQL script into your code, and run it via DoCmd.RunSQL(SQL)

[Missinglinq]

How you approach this really depends on what kind of info you're pulling from TableA and TableB to include in TableC. An Append Query might be appropriate, or something as simple as Comboboxes based on TableA and TableB might work.

A plain language explanation of what you're trying to do would help us help you better.

Welcome to AccessForums!

Linq ;0)>