Import Text File - Problem

[wazza]

Hi

I am automating the import txt file process using vba. For some reason one of my files will not import without errors.

the file contains sales quantities with dates across as coloumns
i.e.

________________________________

product date1 date2 date3 date4
1
2
3
__________________________________

for some reason all the data imports but the last few date fields (coloumn headers of table) i.e. date3 date4 dont import, the field is simply blank but the coloumn data is avaialble

The file imports; delimited, using "" as text identifier
the first row is not used as coloumn headers because the data table doesnt start until row4.. i use similar files and they import fine

* What is my problem...? why is it the last few dates that dont get through?

* is there a way to actually select rows you do not wish to import.. so i can make the datatable header my import coloumn headers?


Regards

 

[wazza]

i tried opening the text file in Excel... im assuming this runs a similar process to access when importing

i use the same specs, delimited and text qualifier ""

all the data goes through fine...?