Good evening everyone,
I have a data set of 500+ CSV files with more than 50K lines of data in each. Through out the data there are a number of empty cells. Unfortunately none of the cells as a fixed width or anything like it. I have included the code I am using to transfer the data in and a sample of a table similar to what I am facing. The question I have to the collective Guru's here is what do I need to update, change or add to keep these blank fields in the data set while not losing any data integrity?
The code I have is:
Workbooks.OpenText filename, , , xlDelimited, xlTextQualifierNone, True, True
A Sample file would be:
<tbody>
</tbody>
I have a data set of 500+ CSV files with more than 50K lines of data in each. Through out the data there are a number of empty cells. Unfortunately none of the cells as a fixed width or anything like it. I have included the code I am using to transfer the data in and a sample of a table similar to what I am facing. The question I have to the collective Guru's here is what do I need to update, change or add to keep these blank fields in the data set while not losing any data integrity?
The code I have is:
Workbooks.OpenText filename, , , xlDelimited, xlTextQualifierNone, True, True
A Sample file would be:
Name | Sandwhiches | Pasta | Drinks | Tables | Color |
Cory | 18 | 43 | 7 | 12 | Yellow |
Tapenga | 12 | 43 | Purple | ||
Eric | 14 | 700 | Red | ||
Mr. Feeny | 170 | Black |
<tbody>
</tbody>