On Monday, December 2, 2013 10:00:31 AM UTC-8, GS wrote:
On Monday, December 2, 2013 9:37:02 AM UTC-8, GS wrote:

I'm inclined to go a different way when pulling data from more than

1



unopen file. ADODB allows you to pull data in recordsets from closed



workbooks, and so is how I would perform this task.







This approach, of course, requires that the columns in the source

files



have headings (field names) that you can use in the SQL statement.



Otherwise, Claus' example is an excellent alternative, IMO!







--



Garry





Hi Garry,



I, for sure, know your stuff works well also.



I don't have a clue what ADODB is, and I see SQL a lot, but also

don't know what it is either. I might be using it and don't know it.



As you know, I can be in over my head in just about no time with some

of this.



I'll keep plugging away and try not to be too frustrating.



Howard



Here's a good 'primer' with example code...



http://www.appspro.com/conference/Da...rogramming.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







---

This email is free from viruses and malware because avast! Antivirus protection is active.

http://www.avast.com

Okay, thanks.

Howard