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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Sandwhiches
[/TD]
[TD]Pasta
[/TD]
[TD]Drinks
[/TD]
[TD]Tables
[/TD]
[TD]Color
[/TD]
[/TR]
[TR]
[TD]Cory
[/TD]
[TD]18
[/TD]
[TD]43
[/TD]
[TD]7
[/TD]
[TD]12
[/TD]
[TD]Yellow
[/TD]
[/TR]
[TR]
[TD]Tapenga
[/TD]
[TD]12
[/TD]
[TD][/TD]
[TD][/TD]
[TD]43
[/TD]
[TD]Purple
[/TD]
[/TR]
[TR]
[TD]Eric
[/TD]
[TD][/TD]
[TD]14
[/TD]
[TD][/TD]
[TD]700
[/TD]
[TD]Red
[/TD]
[/TR]
[TR]
[TD]Mr. Feeny
[/TD]
[TD]170
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Black
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.