When dealing with imported excel worksheets, what would be considered the best method? So far the majority of what I have done is just the transferspreadsheet method, but for some reason or another lately it has resulted in the imported data getting all kinds of jumbled up. I have one module that does it via looping and adding records via DAO (provide by ArnelGP initially).
Are there arguments for one versus the other or is another method just better?
Are there arguments for one versus the other or is another method just better?