Updateing Access DB
in [Programming]
|
From: dstiefe on 2 Jun 2010 14:33 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
From: Ron de Bruin on 2 Jun 2010 15:37 Hi See http://www.erlandsendata.no/english/index.php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dstiefe" <dstiefe(a)discussions.microsoft.com> wrote in message news:DA1F3D53-9EF6-4B7B-ADA4-B2701A815FFC(a)microsoft.com... > 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
From: dstiefe on 3 Jun 2010 10:44 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/index.php?t=envbadac > > -- > > Regards Ron de Bruin > http://www.rondebruin.nl/tips.htm > > > > "dstiefe" <dstiefe(a)discussions.microsoft.com> wrote in message news:DA1F3D53-9EF6-4B7B-ADA4-B2701A815FFC(a)microsoft.com... > > 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 > . >
From: Ron de Bruin on 3 Jun 2010 11:25 No sorry, only one to get data from Access -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dstiefe" <dstiefe(a)discussions.microsoft.com> wrote in message news:4AA14662-9709-486E-B5F4-F890160B1FAF(a)microsoft.com... > 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/index.php?t=envbadac >> >> -- >> >> Regards Ron de Bruin >> http://www.rondebruin.nl/tips.htm >> >> >> >> "dstiefe" <dstiefe(a)discussions.microsoft.com> wrote in message news:DA1F3D53-9EF6-4B7B-ADA4-B2701A815FFC(a)microsoft.com... >> > 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 >> . >>
|
Pages: 1 Prev: Scaling Charts Next: Copy data using macro (with worksheet protect) |