Hi,
I need help in modifying my access vba code. I currently have a sheet that i always import to access. the excel sheet has 4 columns (account id, account name, account period, account period date).
when importing, i would also like access to automatically create an additional field in front of column A (account id) for primary key (auto number).
can anyone help me with this?
Here's the code that I have now:
Please Login or Register to view this content.
Bookmarks