Import External Data

Q

Quintin11

Greetings, all.
I am currently importing some text files into Excel, and wanted to find out
if it's possible to import mulitple files. I can't seem to select more than
one file from the list at this time.
The files are Text, and are all bascially the same. They are space
delimited, and I have no problems using the wizard to import single files.
Since I usually have 8-10 files to import, is there a way to import them as
a group? I sure hope so, my clicking finger is wearing out!
Thanks in advance!
Paul Q
 
J

Jim Thomlinson

The short answer is no. While you know that the file formats are the same XL
doesn't and as such it will not allow multiple file imports.

You could do a macro but it will require a bit of custom coding to allow you
to pick the files... do-able but not for the faint of heart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
import external data 3
Import more than one .csv file into the same Excel file. 1
Import Data, using a command line switch 4
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Import External Data 3
Tab delimited text file import on double click 2
Import txt files into Excel 7

Top