| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
automatically open .txt file with all fields as text?
I need to be able to open a comma separated .txt file so that all fields
are automatically formated as text. I need this so that fields such as "0003" are not converted to numbers which show up as "3". I need to have it imported as "0003". Since there are over 150 fields per record, using the import wizard and manually setting each column as text is less than desirable. Any way to do this automatically? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
| Excel opening but file does not open with Application | Excel Discussion (Misc queries) | |||
| Why Excel file doesn't open by double click. | Excel Discussion (Misc queries) | |||
| How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
| Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
Threaded Mode
