| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Importing Data & Refresh Data
I have for some time updating a worksheet in Excel 2002 from a CSV file. The
source of that file has now switched from comma separated to tab separated. I can't seem to prevent Excel from trying to read the file wrong. I can't even import the tab-separated file into a blank worksheet within the same Excel file. How do I cancel out Excel's inappropriate knowledge of the file so that I can tell it about the tab-separated version? Thank you, George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
| Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
| Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
