Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110378

Re: VBA - Importing Access Query into Excel using ADO

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: VBA - Importing Access Query into Excel using ADO
Date 2017-12-05 03:44 -0500
Organization A noiseless patient Spider
Message-ID <p05ma1$9u0$1@dont-email.me> (permalink)
References <669a58d0-85c0-451b-bfdf-1ed99f014d21@googlegroups.com> <ovlssl$l78$1@dont-email.me> <ef79ec20-de7a-41ee-b219-98b4399abca2@googlegroups.com>

Show all headers | View raw

> On Wednesday, November 29, 2017 at 2:59:10 AM UTC-6, GS wrote:
>> You need to add a WHERE clause to your query so it pulls only the desired 
>> records for the specified valuation year. Rather than write this for you, I 
>> think it better that you review this database programming primer first so 
>> you  have a better idea of how ADODB works as well as how to work with it.
>> 
>>   http://www.appspro.com/conference/DatabaseProgramming.zip
>> 
>> -- 
>> Garry
>> 
>> Free usenet access at http://www.eternal-september.org
>> Classic VB Users Regroup!
>>   comp.lang.basic.visual.misc
>>   microsoft.public.vb.general.discussion
>
> Thanks for the zip file, Garry. Looks like I have a lot of research to do 
> before I dive in! 

Best wishes...

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

VBA - Importing Access Query into Excel using ADO Dennis <dadrad@gmail.com> - 2017-11-28 15:04 -0800
  Re: VBA - Importing Access Query into Excel using ADO GS <gs@v.invalid> - 2017-11-29 03:59 -0500
    Re: VBA - Importing Access Query into Excel using ADO Dennis <dadrad@gmail.com> - 2017-12-04 15:33 -0800
      Re: VBA - Importing Access Query into Excel using ADO GS <gs@v.invalid> - 2017-12-05 03:44 -0500
        Re: VBA - Importing Access Query into Excel using ADO Dennis <dadrad@gmail.com> - 2017-12-05 13:36 -0800
          Re: VBA - Importing Access Query into Excel using ADO GS <gs@v.invalid> - 2017-12-05 16:59 -0500

csiph-web