How do i query flat files

[jmandiaz]

Hi guys,
Is there a way for me to query a list of flat files? If so what would be the best way to do it? thanks in advance

-Jaime

 

[ncar35b]

What type of files? You might want to use MS Index Server. This way, you could set up a catalog and search the files you want. You wouldn't need a database to do this.

 

[jmandiaz]

NCAR35b,
I'm tryin to accomplish the following
For every account that someone opens the system creates a flat file the flat file has an extension of DP which stands for deposit pro it a harland financial product. I want to be able to read the previous instution out of each of those files. What would be the best way to accomplish that?

 

[PHV]

Take a look at Dir, Open, Line Input, EOF and Close in the VBA help.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jmandiaz]

PHV,
what do you mean by EOF? Are saying to open the file in access?

 

[BNPMike]

You probably can use ODBC to link to the file, as long as it is in a simple format. Ask your Helpdesk Support people for an appropriate ODBC driver.

 

[butthead]

instead of saving the data to a flat file
you could save it to a memo field of a table.
Im sure you could code this to write out each
instance to a separate file as necessary.

kinda depends upon how important the separate
files are to your application. and of course
their size.

It just occured to me that you are not using
access to generate the files. is this correct.

if so and you just want to view the files, why
cant you code a simple text veiwer in C or use
notepad. you could load the file into access
using what PHV pointed to.

you said you wanted to view the files. if so, dont
over complicate the solution.

tomcruz.net