I have an Excel as shown in the image below.
- File has 9 columns.
Also shows is a filter on the date field, just to confirm that there are no other data apart from dates.
I am trying to import the data into a online database, which gives me the following import options.
- CSV
- TAB
When I save the file in either of those formats, for some reason the final column occasionally overalls into the data column, even though this issue is not present in the core XLS file.
See below showing the date column no containing other data apart from dates.
Does anyone have some ideas as to how I can fix this without having to go through 1000000's of lines. I have tried using the filter to choose all the non date data but that does not work as it only picks a few of the non date lines.
thanks