Access VBA to add a primary key (first field) after importing to access

**ewong** · 09-13-2012, 04:22 PM

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.

**alansidman** · 09-13-2012, 07:52 PM

Look here
http://www.mrexcel.com/forum/microso...imary-key.html
Alan

**ewong** · 09-14-2012, 01:50 PM

I am using this code right now. So just to confirm, this code is to add primary key field to a table in access right? so i'm new in coding so i wanted to confirm with you that this code (below) basically creates a new field called "ID" as the primary key and it's set to autonumber as well right?

Is there any way to move it to the first column though? When I run the code, it's placed at the last column. I want it to be in the first column though. Thanks

Please Login or Register  to view this content.

Originally Posted by alansidman

Look here
http://www.mrexcel.com/forum/microso...imary-key.html
Alan

**alansidman** · 09-14-2012, 06:52 PM

What happens when you run the code? Did it work? Did it error out?
Posting untested code here is difficult to determine if it will work without seeing the entire db.
Suggest you test and post with issues versus looking for answers before testing.

**ewong** · 09-14-2012, 07:24 PM

it works but it places the field at the end. so the primary key is at the last column at the moment. i want the primary key field to be at the first column instead at the end

**alansidman** · 09-14-2012, 08:57 PM

Here is a site you should visit to hone up on your SQL skills.

http://www.sql-tutorial.com/

I do not know of a way to put it where you want using SQL. Once it is added, you can do a make table query and move it to wherever you wish.