Dear All

Not sure if this is strickly a programming question as the VBA seems to function correctly, however it does get external data and that is where my problem is. Using Excel 2003, I need to import data from a CSV file which changes on a regular basis. I used the 'Get External Data' function and got the query working fine. This continued to work fine for over a year but then, for no apparent reason, the CSV file is truncated

The lengths of the lines in the CSV file change every time it is updated, sometimes their may be 120 cells of data sometimes only 20 and anything in between. Like I said this all worked fine, now however, only part of my data is improted (up to column AH), the rest does not make it into Excel although it is clearly in the CSV file. So I re-created the query and it fixed the problem, for a week! Exactly the same problem has now occured again, this time the data only fills to column AZ, so a slight variation

I am about to fix the problem again, again by recreating the query. I would really like to get the the route of this problem as although work-roundable, it is extreamly annoying and somewhat bizzarre

Should I re-install Excel

Thanks for taking the time to read my waffle

Matthew