Auto Entry in Fields
I am creating a database and am importing tables from Excel as data. Some of the headings from the different Excel tables are the same, but the data is different and Table 1 keeps on auto-entering for table 2, 3, etc. The 50 customer IDs in table 1, automatically enters into my new layout for 20 customer IDs in table 2 so I am left with these repeated numbers and 30 extra lines. How do I stop this without changing the headings?
Thanks for your time and help!