HK> How can i read ASCII comma separated files as tables?
HK> I know you can use scheme files, but they must have the same name as
HK> theascii file. Problem in my case is that the format of the files
HK> stays thesame, but the name changes every day.
HK> Is there a way to use a fixed scheme file for different filenames?
How about the obvious, have some process rename the file to the name you
decide on each day...you are going to have to deal with the filename being
different no matter how you cut it, so take the easy route is my suggestion.
HK> An other question regarding ascci files: i must read in a string var,
HK> but it is not surrounded by quotes, example: 960101,IBM,100
HK> ^^^
HK> How can i do this?
Write a routine to open as a text file and pull out the data you need. You
can then pop it into the database or whatever you are trying to do with it.
Steve
--- FreeMail 1.07b
(1:203/21)
---------------
* Origin: The Visual Programmer's Workshop - N.H., Ca (916)338-3230 *
|