thisisrahul
Active Member
- Joined
- Sep 2, 2008
- Messages
- 286
Hi,
i've an excel in which i am importing data from external .csv file using "Get External Data". This is working fine; but now that external .csv file is changed to .xls file.
Now there is one way that i keep my external file as .csv file, which is not possible since i am using this file for other applications also.
Another way is to modify the existing connection from .csv to .xls, i tried it but it's not happening. Can anyone help me out with how to modify the existing connection to read the new .xls file (from existing connection where i used to read .csv file).
__________
Rahul
i've an excel in which i am importing data from external .csv file using "Get External Data". This is working fine; but now that external .csv file is changed to .xls file.
Now there is one way that i keep my external file as .csv file, which is not possible since i am using this file for other applications also.
Another way is to modify the existing connection from .csv to .xls, i tried it but it's not happening. Can anyone help me out with how to modify the existing connection to read the new .xls file (from existing connection where i used to read .csv file).
__________
Rahul
