Hi all, I am looking for some help in what I should be researching in order to help me tackle the project I am working on.
I do have some experience with access but not advanced enough for something like this.
I am working with land titles in Canada and would like to build a database to import the CSV file we receive with each order.
Here is an example of the data I will be receiving. Titles_Example.txt This is just one title (public data) where I would usually be receiving 100 titles per CSV file and could have multiple of these with each order.
The CSV is created from up to 21 tables during the order and are categorized by the first, three character field that can be seen. Each of these tables contain differing amount of columns ranging from 8 to 21.
I would like some recommendations on what I should be looking for in order to be able to learn how to split the data into the necessary tables with each upload. I have tried to research but I feel I am not using the correct terms so it is hard to find anything relating to similar threads.
The 4th, 6 if reading the couple of blanks, column in each line is the unique title number which I would like to use as the primary key to keep each title linked. From here I can then create forms to re arrange each title into an easier to read format, and from there take it into an excel sheet, if that is the correct way to go, which we will then upload into an online database we currently use (which I do not have any access to in order to help with any data uploads)
So with that being said, what should I be looking at in order to help progress with this.
Thank you for taking the time to read my request and I look forward to reading up on any ideas you are able to give.
I apologize if I am asking too many questions for a single thread, I can adjust my request if needed.