CSV file importing?

[tanneuby]

I recently started using Excel to track my side-business sales. I have
a CSV file sent to me when someone places an order. When I open the
file in Excel, it looks fine everything in the proper places. The
problem is everytime I open a new CSV file, it opens a new Excel sheet.
I want to place the next CSV file in the row below the last one and so
on and so on. The only way I have figured out to do this is to open
each CSV file and highlight-copy-paste the row into the main worksheet.
Is there an easier way?

 

[mzehr]

Hi,
You might try using the Data\Get External Data\Import Text
File option.

It will allow you to set the external Data Range
Properties, allowing for setting different Refresh
Controls, and allows for different Fill Options. In order
to use the data range for another file, you would need to
select the option which prompts you for the file name on
refresh, and would still require some cutting and pasting,
in order to reuse the import area. The nice thing about
this feature is that you don't have to reset the import
features over again.

HTH

 

[Dave Peterson]

You could record a macro when you did it once, then fix up that macro so that it
does all the work for you.

Another option would be to combine the .csv files into a giant .csv file, then
import only that one.

copy a.csv + b.csv + c.csv all.csv

from the command prompt would combine 3 files into one.

 

[On Film]

John Walkenbach has a great set of utilities PUP that, among other
useful features, permits you to combine any type of file into current
worksheet much like we enjoyed in early spreadsheets. A test drive is
available at http://j-walk.com/ss/pup/pup5/index.htm.


Mike