VBA to Import a csv or xls file ONLY as text
Posted on 2010-09-09
I need to import either an excel file or a csv / text file such that the imported table, imports all datatypes as Text and only as Text. If a number or currency or date or time is imported, it still needs to be shown as and stored as text.
And, I need to do this completely automated via VBA.
I've tried a lot, but don't want to bias your solution.