Solved

DoCmd.TransferSpreadsheet adding an autonumber field

Posted on 2008-06-11
1
668 Views
Last Modified: 2008-06-12
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
Comment
Question by:Ellis_F
1 Comment
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
Comment Utility
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

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now