RELATIONSHIPS IN LINKED TABLES

[Guest]

I have a new HIMS application that is able to export data to a shared file in
a CSV file. I am having no problem creating links to these files. I do have a
couple of questions however.

1. Is there a means to create keys to these files. (I understand this to be
no)
2. CAn relationships be created on these tables ( seems to be no also)
3. Would creating RWOP queries work and if I understand correctly then I
should be able to create relationships on these queries.
4. I do not think converting the tables to local will be a solution since
the data is not static data. I update the txt files as needed.
5. There will be no reason to update the files from within Access merely
creating queries and pivot tables for data analysis.
6. Records are unique (primary) by Custumer number and visit number fields.


Please advise or suggest alternatives

 

[Guest]

Create your tables in Access and define the primary key and index fields in
design view.
Create the relationships in Access.
Create Import Specifications for the imports.
Import into the existing tables rather than making new tables.

 

[Guest]

Since this data is dynamic not static I assume then that I will need to
delete all records in the new table prior to import. Or is there a means to
just update the existing records and add new records. I think I am wishing
for the moon here. Gotta try.

 

[Guest]

I am thinking an import will replace the existing data, but if I am wrong,
you can delete the existing data prior to executing the import:

CurrentDb.Execute("DELETE * FROM MyTableName;"), dbFailOnError

Be sure you have cascading deletes and updates set to yes.