hello,
I've got a project at work and I have to query some information from a number of excel files. They are the exact same format, so I was thinking that rather than querying each of them (via query analyzer), I would like to consolidate them all into one large spreadsheet.
Does anyone know of an easy way to do this?
Thanks for the help!