Auto number field Outlook 2003

[FrankSpokane]

I would like to import 153 records from an Excel spreadsheet that have a
Jobnumber Field that now has 153 as the highest number, and I would like
Access to import these and then assign the next Jobnumber as 154 and
increment it from here - Is there a way to do this?

Thanks for all tips.

 

[John W. Vinson]

I would like to import 153 records from an Excel spreadsheet that have a
Jobnumber Field that now has 153 as the highest number, and I would like
Access to import these and then assign the next Jobnumber as 154 and
increment it from here - Is there a way to do this?

Thanks for all tips.

Create the table first, with an autonumber field.

Use File... Get External Data... Link to link to the Excel spreadsheet, and
then create an Append query to append the data into the new table (it will
import the job number from the spreadsheet into the autonumber field, the only
way you can write to an autonumber!).

What does Outlook 2003 have to do with the problem? Was that just a typo?

John W. Vinson [MVP]

 

[FrankSpokane]

Create the table first, with an autonumber field.

Use File... Get External Data... Link to link to the Excel spreadsheet, and
then create an Append query to append the data into the new table (it will
import the job number from the spreadsheet into the autonumber field, the only
way you can write to an autonumber!).

What does Outlook 2003 have to do with the problem? Was that just a typo?

John W. Vinson [MVP]

Thanks - I meant Access instead.