Appending to a table using VB (instead of Append Query)

[rcoutts]

I have a report that I am building that is based on a table with three columns. At the moment I build the table using an Append Query, but since I don't know SQL very well and build all my queries using Design View, its getting a little intractable. I currently do all my calculations in VB, export the data to separate tables, and then build the final table using an Append Query. I'm starting to think that it would be easier for me to just append the records to my table directly from VB, instead of writing them to a separate table and then doing running my Query.

My question is, how do you append records to a table directly from VB? I thought of having a table that's a single record that would act as a scratch table and just write to that and have a simple query that then appends it, which would work fine, but doesn't seem very elegant. Is there a simpler way to do this?

Thanks!
Rich

 

[tomschafer]

How are you doing this?
"I currently do all my calculations in VB, export the data to separate tables"
Check out RecordSets and the .AddNew and .Update functions for RecordSets. Let me know if you need more direction.