• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 812
  • Last Modified:

DoCmd.TransferSpreadsheet adding an autonumber field

Hi

I am using the DoCmd.TransferSpreadsheet function to import data into access. Is there a way to create a new field in the imported table called ID that is an autonumber and a primary key within the vba?

Thanks
0
Ellis_F
Asked:
Ellis_F
1 Solution
 
tbsgadiCommented:
Hi Ellis_F,

The easiest way is to create the table in Access (with an autonumber) & import into that table. (If necessary deleting previous data.


Good Luck!

Gary
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now