LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
George
 
Posts: n/a
Default Importing Data & Refresh Data Problem

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 have tried
renaming to .txt and .tab to no effect. I can't even import the tab-separated
file into a blank worksheet within the same Excel file. The import text
wizard will not start up. It seems that Excel knows about the original file
and I haven't figured out how to remove that information. 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Data & Refresh Data George Excel Discussion (Misc queries) 3 March 26th 05 09:19 PM
Glue/Lock cells to external data before refresh Jo Betty Smith Excel Discussion (Misc queries) 0 February 16th 05 11:55 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
External data Macro Problem Excel 97 Craig Kelly Excel Discussion (Misc queries) 1 January 17th 05 03:17 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"