I am trying to figure out a way to import data to my MS Access database from information provided by my client via an online form. The problem I am having is the nature of the one-to-many aspect of MS Access and the fact that the export of jotform data is in csv format. So for example, my form asks the client to list their medications and details about each medication. Very annoying that jotforms solution is just to give you as many blanks as would be realistically possible, but I could not find much else out there. So, the result is a messy excel file with just one row that just has one medication and its detail after the other - no meaningful column names, just a mess. Any ideas?
OK. So I have uploaded the excel file that JotForm gives me when I download. This is a given clients list of jobs she has done for the past 15 years. As you can see, all jobs have simply been strung on to the same row. I would imagine I need an excel file with a seperate row for each job in order for me to import into my MS Access DB that lists a given client's job in a "Jobs" table.
I looks like this jotforms generated spreadsheet includes a number that designates each job in the description, like "Please List All Jobs in the Last 15 Years (STARTING WITH MOST RECENT JOB) >> 1 >> Approximate Start Date" where we are dealing with the first job.WorkHistoryRedacted.zip