Updateing Access DB
 

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

Updateing Access DB
 

Hi

See
http://www.erlandsendata.no/english/...php?t=envbadac

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"dstiefe" wrote in message ...
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

Updateing Access DB
 

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!

"Ron de Bruin" wrote:

Hi

See
http://www.erlandsendata.no/english/...php?t=envbadac

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"dstiefe" wrote in message ...
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
.

Updateing Access DB
 

No sorry, only one to get data from Access

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"dstiefe" wrote in message ...
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!

"Ron de Bruin" wrote:

Hi

See
http://www.erlandsendata.no/english/...php?t=envbadac

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"dstiefe" wrote in message ...
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
.

Subject: Updateing Access DB
 

You need a delete query to do this. See this:
http://www.databasedev.co.uk/delete_query.html


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.