VBA - Importing CSV files with blank fields to Access

[AHalpain]

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:

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>

 

[carpy1985]

Hi,

are you having trouble when uploading the data to access?

also how are you uploading the data to access? via excel or via access direct?

 

[AHalpain]

I am trying run it directly through the VBA to run it in the background So i guess that would be directly into access.