Convert from Excel and change field to Autonumber

D

Dan Pickard

Hi,

I have an Excel file which I have opened in Access to create an access table
which is fine. I am now quickly going through the fields to tweak them to
what they should be but the Excel file was created from a Lotus Approach
database that had a field which was autonumber. Obviously when I try to
change the field in the Access database it tells me that it can not do this
as there is data in the table.

What is the proper procedure to do this and either make the field an
autonumber field during conversion or after?

--
Dan Pickard
-----------------------------
Powerful Windows 2003 web hosting, design and training.
http://www.hosting.fast-trak.net
http://www.design.fast-trak.net
http://www.training.fast-trak.net
http://www.fast-trak.net
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
How do you get rid of the forms vertical bar? 3
Relationships - I have the wrong one 2
Dynamic Naming of Form Button 3
Autonumber records inserted in gaps 0
convert a number to an autonumber 4
MS Outlook inbox to MS Accsess Database 0
Autonumber field changes to random from sequential 3

Top