This is probably wishful thinking, but is there a way to import one text
file into Column A, for example, and another text file into Column B, so
they line up next to each other ? They are large files, so I don't
want to have to cut and paste, if possible.
Thanks for any help !--
tcurrier
------------------------------------------------------------------------
tcurrier's Profile: www.excelforum.com/member.php...oamp;userid=31279
View this thread: www.excelforum.com/showthread...hreadid=511362Click A1
select data--gt;get external date--gt;import text file
click your way through
then click the next where you want the other file to appear
do the same
HansYou don't give any version details, but if this is XP or 2003 then go to
Datagt;Import External Datagt;Import Data. This sets an OLEDB connection where
you can select any datasource. (.txt files are one). You then get what looks
like the text import wizard dialogues, with a few bells and whistles, once
you complete this wizard you get asked where to put the data, select A1,
then do the same on file2 and select B1
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;tcurrierquot; gt; wrote in
message ...
gt;
gt; This is probably wishful thinking, but is there a way to import one text
gt; file into Column A, for example, and another text file into Column B, so
gt; they line up next to each other ? They are large files, so I don't
gt; want to have to cut and paste, if possible.
gt;
gt; Thanks for any help !
gt;
gt;
gt; --
gt; tcurrier
gt; ------------------------------------------------------------------------
gt; tcurrier's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31279
gt; View this thread: www.excelforum.com/showthread...hreadid=511362
gt;
Thanks for you help, guys... It works great.. I didn't realize that
option was there....--
tcurrier
------------------------------------------------------------------------
tcurrier's Profile: www.excelforum.com/member.php...oamp;userid=31279
View this thread: www.excelforum.com/showthread...hreadid=511362
- Aug 14 Mon 2006 20:08
Import 2 text files into 2 separate columns?
close
全站熱搜
留言列表
發表留言