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 revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
| data_load_problem_how_to_join_many_csv_files_together [2008/09/11 13:57 (16 years ago)] – cliff | data_load_problem_how_to_join_many_csv_files_together [2008/09/11 13:58 (16 years ago)] – cliff | ||
|---|---|---|---|
| Line 6: | Line 6: | ||
| ==== Step 1 ==== | ==== Step 1 ==== | ||
| Place the following code into a module in Excel. | Place the following code into a module in Excel. | ||
| - | <code|x> | + | < |
| Sub Main() | Sub Main() | ||
| Line 41: | Line 41: | ||
| | | ||
| End Sub | End Sub | ||
| - | </code|x> | + | </ |
| ==== 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