Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
chris_rip
 
Posts: n/a
Default how do i import multiple data sets at one time?

I'm importing a bunch of data and I'm using the import external data command
in the data menu. I click on my file and choose delimited and then add a
space in the next screen. It turns out to be two columns of data. I do this
10 times and was wondering if there is a way to import all the data at one
time to simply save time. If anyone out there has any ideas I'd love to hear
them. Thanks in advance.
  #2   Report Post  
Bryan Hessey
 
Posts: n/a
Default


Assuuming that the files are all of the same two-column format, in a DOS
Command Prompt window:
Copy File1.txt + File2.txt + File3.txt + File4.txt + File5.txt
File2Import.txt
and import the combined file


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=381070

  #3   Report Post  
chris_rip
 
Posts: n/a
Default

I tried this method and was able to bring in the numbers. The problem is
that they come in on top of each other and also I need to put a space between
the two numbers to make them in different columns. I tried to do a set of 10
data files and I saw 2 sets directly on top of each, meaning that one set was
A1 to A1000 and the other set was A1001 to A2000. Within each cell there are
2 different numbers and I need them to be in separate columns. Also, I
didn't see the other 8 sets of data. Ideally, I'd like to see them side by
side 1:1000 with a space between each two columns. I'm not sure if this is
possible using a dos command. Let me know if you have any other suggestions
or need any other info. from me. Thanks again.

"Bryan Hessey" wrote:


Assuuming that the files are all of the same two-column format, in a DOS
Command Prompt window:
Copy File1.txt + File2.txt + File3.txt + File4.txt + File5.txt
File2Import.txt
and import the combined file


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=381070


  #4   Report Post  
Bryan Hessey
 
Posts: n/a
Default


To put a space between the two numbers (ie, to place into separate
columns) is done via the Data, Text-to-Columns option.

However your data appears to be multiple variations (files) of the same
information, ie that you have 1:1000 in the first file (followed by a
number) and data relating to 1:1000 in a second (third and fourth)
file.

Try to copy the data (from Notepad) and paste into cell D1 (then G1 for
the third file, then J1 for the fourth file etc.)

Hope this produces the result you are looking for,
. . . or is there a need to mix-and-match the data line items?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=381070

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time in data validation? Cymro Excel Worksheet Functions 1 June 8th 05 03:52 PM
looking for a calendar template that I can import multiple dates bkrizman Excel Discussion (Misc queries) 0 June 1st 05 11:16 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Import External Data Jeff Excel Worksheet Functions 0 May 3rd 05 10:28 PM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 07:52 PM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"