Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
bring .tps files into excel
I have many .tps files that I need to open up in excel. Does anyone know a
good way to convert .tps files to text or something to open in excel? thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
bring .tps files into excel
What is it?
http://www.fileinfo.net/extension/tps Knox wrote: I have many .tps files that I need to open up in excel. Does anyone know a good way to convert .tps files to text or something to open in excel? thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
bring .tps files into excel
It is the clarion database file, a database of traffic counts
"Bob I" wrote: What is it? http://www.fileinfo.net/extension/tps Knox wrote: I have many .tps files that I need to open up in excel. Does anyone know a good way to convert .tps files to text or something to open in excel? thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
bring .tps files into excel
What does it look like if you open it with Notepad.exe? Is it really a
comma delimited file? Knox wrote: It is the clarion database file, a database of traffic counts "Bob I" wrote: What is it? http://www.fileinfo.net/extension/tps Knox wrote: I have many .tps files that I need to open up in excel. Does anyone know a good way to convert .tps files to text or something to open in excel? thank you! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
bring .tps files into excel
no, it is just a bunch of symbols and stuff, it can't read it properly
"Bob I" wrote: What does it look like if you open it with Notepad.exe? Is it really a comma delimited file? Knox wrote: It is the clarion database file, a database of traffic counts "Bob I" wrote: What is it? http://www.fileinfo.net/extension/tps Knox wrote: I have many .tps files that I need to open up in excel. Does anyone know a good way to convert .tps files to text or something to open in excel? thank you! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
bring .tps files into excel
You may need to open it in Clarion and do an Export then.
Knox wrote: no, it is just a bunch of symbols and stuff, it can't read it properly "Bob I" wrote: What does it look like if you open it with Notepad.exe? Is it really a comma delimited file? Knox wrote: It is the clarion database file, a database of traffic counts "Bob I" wrote: What is it? http://www.fileinfo.net/extension/tps Knox wrote: I have many .tps files that I need to open up in excel. Does anyone know a good way to convert .tps files to text or something to open in excel? thank you! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
bring .tps files into excel
As Bob I suggested, probably the easiest route is to use Clarion to export to
a comma separated values (.csv) file or to a raw .txt file. You can then read either into Excel pretty much directly. You can also open either of those types with Notepad to see how they're laid out. Remember that .csv doesn't necessarily always mean "comma" separated values, other characters frequently used in those types of files are the [Tab] character, the pipe ( | ), and the semi-colon (;). Or Clarion may output to a fixed field length text file - which Excel can import once you figure out how long the fields are. "Knox" wrote: no, it is just a bunch of symbols and stuff, it can't read it properly "Bob I" wrote: What does it look like if you open it with Notepad.exe? Is it really a comma delimited file? Knox wrote: It is the clarion database file, a database of traffic counts "Bob I" wrote: What is it? http://www.fileinfo.net/extension/tps Knox wrote: I have many .tps files that I need to open up in excel. Does anyone know a good way to convert .tps files to text or something to open in excel? thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring back .dbf in Excel | Excel Discussion (Misc queries) | |||
How do I bring Lotus123 files over in to Excel | Excel Discussion (Misc queries) | |||
How do I bring a trendline in front of an object in Excel? | Charts and Charting in Excel | |||
how do i bring information from one worksheet to another in excel. | Excel Worksheet Functions | |||
how do I bring balances forward in Excel | Excel Worksheet Functions |