|
Home > Archive > MS Access data conversion > August 2005 > Convert from Excel and change field to Autonumber
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Convert from Excel and change field to Autonumber
|
|
| Dan Pickard 2005-08-15, 9:24 am |
| 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
| |
| Dan Pickard 2005-08-15, 9:24 am |
| It's OK, I used an append query to sort it. Thanks for looking though.
--
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
"Dan Pickard" <daniel.pickard@NoSpamfast-trak.net> wrote in message
news:U- OdndCWR4RFCJ3eRVnyrw
@pipex.net...
> 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
>
|
|
|
|
|