Home |
Search |
Today's Posts |
#1
|
|||
|
|||
get external data
I am trying to get a .txt file under
<data-getexternaldata-newdatabasequery. I succeeded in downloading that text flle. I undestand it is possible to get that data direct into columns , instead downloadings that file and using texttocolumns . any suggestions. The information is perhaps avilable in <help-ODBC setup I am unable to get at that help thanks and regards. |
#2
|
|||
|
|||
You neglected to mention which version of Excel you are using, and that can
make a difference. You may be able to simply Open the text file and use a Wizard to set the columns if the data isn't compliant with comma, tab, or other common delimiters. Regards |:) "R.VENKATARAMAN" wrote: I am trying to get a .txt file under <data-getexternaldata-newdatabasequery. I succeeded in downloading that text flle. I undestand it is possible to get that data direct into columns , instead downloadings that file and using texttocolumns . any suggestions. The information is perhaps avilable in <help-ODBC setup I am unable to get at that help thanks and regards. |
#3
|
|||
|
|||
sorry . mine is excel 2000
CyberTaz wrote in message ... You neglected to mention which version of Excel you are using, and that can make a difference. You may be able to simply Open the text file and use a Wizard to set the columns if the data isn't compliant with comma, tab, or other common delimiters. Regards |:) "R.VENKATARAMAN" wrote: I am trying to get a .txt file under <data-getexternaldata-newdatabasequery. I succeeded in downloading that text flle. I undestand it is possible to get that data direct into columns , instead downloadings that file and using texttocolumns . any suggestions. The information is perhaps avilable in <help-ODBC setup I am unable to get at that help thanks and regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
Excel 97/2000 - Help with looking up external data. | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
parameters option on the external data toolbar is not available | Excel Discussion (Misc queries) |