Upfront - I am a newbie to Access (so be gentle!).
I am converting an flat excel file containing sale and purchase transactions to an Access relational database - 12 out of the 37 columns have repeating values. I have created individual tables for these values and the base table of transactions is linked to them. I can query the data, so everything seems to work correctly, but now I need to add data. The input comes from excel in the same flat file format.
I have tried a number of queries, but they don't append correctly. I can't share the data as it is confidential, but will work up a simple example. In the meantime, if anyone has any pointers - I would appreciate it!
I am converting an flat excel file containing sale and purchase transactions to an Access relational database - 12 out of the 37 columns have repeating values. I have created individual tables for these values and the base table of transactions is linked to them. I can query the data, so everything seems to work correctly, but now I need to add data. The input comes from excel in the same flat file format.
I have tried a number of queries, but they don't append correctly. I can't share the data as it is confidential, but will work up a simple example. In the meantime, if anyone has any pointers - I would appreciate it!