Import more than one .csv file into the same Excel file.

M

Mary Ann

I have several .csv files which were created by saving data from Word forms.
I want to be able to import all the files into the same Excel file. I have
used the Get External data, Import text file commands to import the first,
but this is not available to import the second. If I choose the Edit import
option it replaces the row of data I already have from my first import.
I am using Excel 2003.
 
J

Jacob Skaria

Why dont you merge the .csv files together using MS- DOS copy command.

--Copy all .csv files to a single folder (say c:\temp\)
--From command line type the command
copy c:\temp\*.csv c:\All.csv/b
--Open c:\All.csv from Excel

If this post helps click Yes
 

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

Exporting Outlook 2007 contact list without losing groups 0
Import Multiple CSV Files from Same Folder into Open Workbook 5
Create a dynamic master file 1
Adding data to MS Access from csv file 0
Excel And Notepad 3
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Cannot import CSV file into ACCESS 1
More than one ondedrive on the same computer 0

Top