Hi all, currently learning how to use MS Access/Excel and ran into a problem with importing my tables into access.
If I have my data sorted like this,
is there an easier way to copy down the Invoice/CustPO/Date etc. down into the blank spaces than simply doing it manually? When I attempt to import it into Access, it wont let me set PK's due to the above blank spaces.
If I have my data sorted like this,
is there an easier way to copy down the Invoice/CustPO/Date etc. down into the blank spaces than simply doing it manually? When I attempt to import it into Access, it wont let me set PK's due to the above blank spaces.