Using Column with Blanks for Primary Key (Access & Excel)

Long story shorter, I have an Excel sheet that I'm trying to incorporate into Access. The issue is, that my current Excels sheet contains blanks in the A column. That same A column would also be the primary key for the Access Table import, which it doesn't like/work. So, what's the best way of going about this? I thought of making a second Excel sheet, which references the first, except the referenced A column contains a formula which refers to the original sheet. I cannot remove blanks either in VBA or some other method because of these formulas.

A good note is this Excel sheet is constantly updated, so I have code in VBA to systematically update the Table in Access with the new information from the Excel sheet, it's just Im not sure how to solve this trivial question without tampering/ruining the original excel sheet.

How can you have a primary key for a record that is blank? Perhaps you should just insert a column A and have it number 1 up to be your primary key. Primary keys need to be unique and blanks do not fall into that category.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have dont it for you this time, but you'll be expected to do it yourself in future.)