Link Table Methodology Question

[supanoods]

Hi - I have a general method question,

I have to create an ACCESS db that uses a big .CSV file on the company server. The .CSV is replaced and updated daily, but the field structure remains the same every time.
I need to find one column of info from the .CSV based upon filtering 3 other columns.

Eg: I need to know the different "Problem Codes" based upon the "Area", "Person", and "Property". All of which are in the .CSV. NOTE: "Property" can have MANY "Problems Codes".

The question is - what is the best method to do this? Should I query the linked data table directly, should I do a query on the table first, do I need multiple queries or is just as straightforward as doing it all on one query?

I have a good understanding of Access - but if someone can propose the best method I would greatly appreciate any input!

Cheers - SupaNoods


"If it aint broke - dont fix it!

 

[Hap007]

Dear SupaNoods,

Based on what you described, a CSV file that changes daily, but the structure remains the same:

I would suggest you create an import procedure that is run when your application starts or when you need to reference this data.

I would import the data into a local, temporary table and then query that local table for the information required.

Hope this Helps,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[supanoods]

Hap007,

Thanks for your reply.

To be honest I'm a little fuzzy on the coding involved in the whole data import thing. I can do it manually fine - no probs, but this system needs to be fully automatic.

I can learn the code, but for deadline reaons do you think I can still work on a linked table to query data?

Cheers - Supanoods B-)

"If it aint broke - dont fix it!

 

[supanoods]

Just to finish this off - I figured the best way out!

"If it aint broke - dont fix it!