Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110370
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: VBA - Importing Access Query into Excel using ADO |
| Date | 2017-11-29 03:59 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <ovlssl$l78$1@dont-email.me> (permalink) |
| References | <669a58d0-85c0-451b-bfdf-1ed99f014d21@googlegroups.com> |
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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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