Importing Excel Spreadsheets with Primary Key

[skinny220]

Is there a way I can run a Macro or SQL to import an excel spreadsheet and assign a primary key without using the wizard.

 

[Joe4]

Sure. Set up the table ahead of time, so you have am empty table set-up just the way you like it with all the field names.
Then import the Excel sheet into that table. As long as your fields names line up and your data is in the correct format, it should work.

The Macro command for importing Excel sheets is TransferSpreadsheet.
See: https://msdn.microsoft.com/en-us/library/office/ff844793.aspx