Interesting Problem

[mike1971]

Hi there....

Has anybody ever come against an issue where Access will cut lines of data off a excel upload depending on the excel version the file is saved under?? For example, I am uploading a daily file which when saved as excel 97 loses lines upon upload, I've been told that if I save under excel workbook (default) then this will not happen but what does happen is that the code will not recognise the format...very frustrating.

have a nice day...

 

[Savil]

One possibility is that Excel has a limitation of 65000 rows, anything over that will not be exported. Try saving your file as a .csv, this will then export all the rows. If you view the file using Excel you will only be able to view the first 65000, the rest are there but not visible. Open the file using either wordpad or notepad.

 

[mike1971]

thanks, but not that simple I'm afraid. This is a file which has <65,000 lines, for some reason it ramdomly excludes lines for no apparent reason, ie data types, null values etc.. This seems to be totally reliant on the excel version type.