Adding data to MS Access from csv file


Joined
Mar 29, 2012
Messages
1
Reaction score
0
I am trying to update client records from information provided in a Zoho online form - a csv file. The data, however, is spread over several tables and involved one to one and one to many relationships.
Screenshot (1).png



My Zoho form asks my client to give me details on the medications they are currently taking. But this simple request has implications across the tables. A medication is a MedicalTreatmentEvent, which has its own autonumber. And a MedicalTreatmentEvent pertains to a given medical condition, an ClientImpairment which has its own autonumber, ClientImpairmentID. So when the client enters "Dpression" in the "what for" blank in the Zoho form, we know this entails creating a record in ClientImpairment and getting a ImpairmentID autonumber issued. And of course the MedicationID has to be linked to MedicalTreatmentEventID, so there are just a few moving parts here. I don't know whether my VBA code should break it up, or try to achieve it in one big append query?
 

Attachments

  • Screenshot (2).png
    Screenshot (2).png
    115.8 KB · Views: 1
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top