rookie
|
Posted: 12/16/2003, 11:19 AM |
|
hi,
I have a .txt file, the fields are diveded with ":"
how can i display this fields on a asp page?
|
|
|
ryan
|
Posted: 12/17/2003, 3:58 PM |
|
I am not sure if colon ":" are allowed delimiters other than
tab or comma ","
Normally I would make sure that these are all commas, my flat file name flatfile.csv would have this data inside
"itemcode","product","pack","price","productreleasedate"
"108098","SB","36x440",11.29,1999-10-22 00:00:00
"108197","FG","36x440",13.29,1997-12-11 00:00:00
"108104","JGH","36x440",11.29,1987-08-19 00:00:00
This is valid csv, not txt or whatever
You need an ODBC instance for this get to tweak the Sytem DSN of your ODBC in control Panel and point where the csv flat file is.
Then you have to check the csv (allowed extension name) and voila you just created and ODBC instance.
You can then use CCS to use that ODBC say the name is PRODUCTS, use the Microsoft Text Driver and there you have displayed your CSV to your ASP using ODBC.
Movement of your code to other machines means recreating new ODBC instance of course. And the csv as well
Ryan
|
|
|
|