Prev: Scaling Charts
Next: Copy data using macro (with worksheet protect)
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)