Updateing Access DB

D

dstiefe

Can someone point me in the right direction to write the VBA to "Append" and
data table in Access..

I have the code to connect...and I have the SQL Statement...just not sure
how to write the code to "Append" the data

Thank you
 
D

dstiefe

Thank you..

Do you have a similiar link to the code that would "delete" a set of records
from a table...based on a date for example?

thank you again!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i write data from Excel to a table in Access (2007)? 4
Example Of VBA SQL Statement 0
Treating WorkSheet As MS Access Table? 2
Insert line in first row of CSV text file with VBA 2
How to export table from outlook into ms access table? 0
rs.addnew - named range vs. individual cell 1
append all instead of one 5
Access Macro Repeat Expression using value of a field in table 0

Top