Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've been trying to import sheets from an excel spreadsheet and using the 'table files' option to do so. The columns show up in the 'table files' selection part correctly, but then between reloading and putting those columns into a table box, the data gets muddled up and puts data from other columns into the wrong ones. I don't have any idea what's causing this or how to fix it, so help would be great. Thanks.
Fields in text-files could contain special chars like tabs and so on, which could cause some problems, but in excel is it rather unlikely ... Put a rowno() command in your load to find these rows and have a closer look on these data parts (sometimes is here a hex-editor helpful).
- Marcus