Hi there.
I have a base file linked to a directory of csv files.
My problem is, I can't seem to change how the fields are read in the database.
I've read somewhere that they are decided on by reading the second line of the csv (after the headers) and then whatever datatype is present in the column will decide the field type for the whole column.
I've done some testing with this and it looks like I'm getting random results with how the data is read. I want the data as a number type so I can make a SUM with the column when imported to calc. however quite often the data is read as a TEXT field and causes problems.
the csv file is updated daily from the internet hence the csv directory structure.
Any help would be appreciated.