Hi all,
A friend has over 100 files which are a mix of Excel sheets and CSV files.
She needs to pull individual columns from the files into one huge file and
to generate reports and to run queries. The files have a similar layout but
she is not sure if the columns are in the same order. However, the column
names she has to extract are the same across the files.
How can this problem be resolved? One way is to write a script to merge the
files. However, are there other ways? We had thought Microsoft Access but
that has a 2GB file limit and I do not see a way to batch import files.
Pranav
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
