User Tools

Site Tools


data_load_problem_how_to_join_many_csv_files_together

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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)] cliffdata_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>+<code>
     strFolder = "M:\Docs\WindwardCustomers\GraniteCity\Inventory"     strFolder = "M:\Docs\WindwardCustomers\GraniteCity\Inventory"
-</code|x>+</code>
 ==== 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>+<code>
     Set objFile = fso.CreateTextFile("M:\Docs\WindwardCustomers\GraniteCity\AppendedInv.csv", ForAppending, False)     Set objFile = fso.CreateTextFile("M:\Docs\WindwardCustomers\GraniteCity\AppendedInv.csv", ForAppending, False)
-</code|x>+</code>
  
 ==== Step 4 ==== ==== Step 4 ====
 Run the macro in Excel. A message box saying "Done" will popup when the files have been combined. Run the macro in Excel. A message box saying "Done" will popup when the files have been combined.
  
data_load_problem_how_to_join_many_csv_files_together.txt · Last modified: 2008/09/12 09:49 (16 years ago) by cliff