data_load_problem_how_to_join_many_csv_files_together
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
data_load_problem_how_to_join_many_csv_files_together [2008/09/11 13:58 (16 years ago)] – cliff | data_load_problem_how_to_join_many_csv_files_together [2008/09/11 13:58 (16 years ago)] – cliff | ||
---|---|---|---|
Line 45: | Line 45: | ||
==== Step 2 ==== | ==== Step 2 ==== | ||
Modify a line in the code, change the path to the directory where your csv files reside. | Modify a line in the code, change the path to the directory where your csv files reside. | ||
- | <code|x> | + | < |
strFolder = " | strFolder = " | ||
- | </code|x> | + | </ |
==== Step 3 ==== | ==== Step 3 ==== | ||
Modify a line in the code, change the path to the directory where your combined file will go. Do not choose the same directory as the where the csv files reside. | Modify a line in the code, change the path to the directory where your combined file will go. Do not choose the same directory as the where the csv files reside. | ||
- | <code|x> | + | < |
Set objFile = fso.CreateTextFile(" | Set objFile = fso.CreateTextFile(" | ||
- | </code|x> | + | </ |
==== Step 4 ==== | ==== Step 4 ==== | ||
Run the macro in Excel. A message box saying " | Run the macro in Excel. A message box saying " | ||
data_load_problem_how_to_join_many_csv_files_together.txt · Last modified: 2008/09/12 09:49 (16 years ago) by cliff