ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing External Data From Several Files (https://www.excelbanter.com/excel-discussion-misc-queries/110155-importing-external-data-several-files.html)

Eric O'Connor

Importing External Data From Several Files
 
I have a folder full of *.CSV files, and I'm able to import them into a
workbook by using the Import Data command, but this only imports a single
file at a time. I would like do import all of the csv files without having to
import each one.

Dave Peterson

Importing External Data From Several Files
 
Into the same worksheet?

See Ron de Bruin's site:
http://www.rondebruin.nl/csv.htm

Eric O'Connor wrote:

I have a folder full of *.CSV files, and I'm able to import them into a
workbook by using the Import Data command, but this only imports a single
file at a time. I would like do import all of the csv files without having to
import each one.


--

Dave Peterson

Eric O'Connor

Importing External Data From Several Files
 
Yea, there are 55 CSV files in one folder that I would like to import into
one worksheet.

"Dave Peterson" wrote:

Into the same worksheet?

See Ron de Bruin's site:
http://www.rondebruin.nl/csv.htm

Eric O'Connor wrote:

I have a folder full of *.CSV files, and I'm able to import them into a
workbook by using the Import Data command, but this only imports a single
file at a time. I would like do import all of the csv files without having to
import each one.


--

Dave Peterson


Dave Peterson

Importing External Data From Several Files
 
Then see Ron's site.

Eric O'Connor wrote:

Yea, there are 55 CSV files in one folder that I would like to import into
one worksheet.

"Dave Peterson" wrote:

Into the same worksheet?

See Ron de Bruin's site:
http://www.rondebruin.nl/csv.htm

Eric O'Connor wrote:

I have a folder full of *.CSV files, and I'm able to import them into a
workbook by using the Import Data command, but this only imports a single
file at a time. I would like do import all of the csv files without having to
import each one.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com