Information générale
Catégorie:
COM/DCOM et OLE Automation
> In theory, importing from CSV, indeed, seems better to me. I also suspect > you can insert it into any place.
> Try if you can pre-format the column, where you will insert the CSV, as text.
As far as I can tell, opening a .CSV file in Excel always starts a new sheet so the pre-format of the columns as text is left unused on another sheet.
Also, I should mention my previous post I accidently showed a space following the comma in my example .CSV file which must be omitted for the other columns to load properly.
I am also considering adding the extra "=" prefix character only if I really need it to prevent the data conversion. Unfortunately, this could be an intensive effort since things like "7440-09-7" should never have been assumed to be a date. UGH! As a related question, is there any fast way test if a string contains any alpha character? So for example I would add the "=" prefix if I had a code like "7440-09-7" with dashes in positions that might be dates, but not for codes like "7A40-09-7" that had an alpha character.
Thanks,
Jeff
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement