Importind data from several files

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

Hi,

I need to import data from several files into a single
worksheet every month. I wish I could do this in the most
automatic way possible (I didn't want to repeat the
import process for each file).

Is this possible?

Thanks
 
On Fri, 17 Oct 2003 10:13:41 -0700, "Jo" <[email protected]>
wrote:
How about trying on the Excel menu...... Data/ Get External Data/ New
Database Query...
Then choose a workbook and start a query using Excel files* as the
data source . Combine the different workbooks. You have to look into
defining names in the workbooks and initially you may have to do a lot
of fussing with this but MSQuery will let you pull this off. I only
suggest that at some point when you get the query the way you like
save it as an external query from the worksheet so that if anything
happens you can use it again in a new workbook.
Scott
 
Back
Top