Adding a index automatically...

Hi, still new to all this I'm afraid! I've created a DTS routine that copys some table data from an Access database into another Access database. In the second mdb, I would like the routine to add an ID field and populate all the lines. I'm sure it must be kind of easy but I can't find how!

Any help appreciated.Ah sorted - just added the ID as an Identity when the table was being created in the routine.

adding a datestamp automatically

Hi,
As a convert from Access, I need a little help please.
I need to get a datestamp into a new record when it is created.
I can see the line for Default Value, but don't know what code to insert
here.
Many thanks,
NEIL
In news:csisi5$9ge$1$8300dec7@.news.demon.co.uk,
Neil Jarman <neil@.tNOiSPAMvPLEASEy.co.uk> said:
> Hi,
> As a convert from Access, I need a little help please.
> I need to get a datestamp into a new record when it is created.
> I can see the line for Default Value, but don't know what code to
> insert here.
Default should be:
getDate()
Steve
|||Hi Steve,
Many thanks!
NEIL
"Steve" <steve@.somewhere.invalid.com> wrote in message
news:FH6Hd.958160$2W1.74289@.news.easynews.com...
> In news:csisi5$9ge$1$8300dec7@.news.demon.co.uk,
> Neil Jarman <neil@.tNOiSPAMvPLEASEy.co.uk> said:
> Default should be:
> getDate()
> --
> Steve
>

adding a datestamp automatically

Hi,
As a convert from Access, I need a little help please.
I need to get a datestamp into a new record when it is created.
I can see the line for Default Value, but don't know what code to insert
here.
Many thanks,
NEILIn news:csisi5$9ge$1$8300dec7@.news.demon.co.uk,
Neil Jarman <neil@.tNOiSPAMvPLEASEy.co.uk> said:
> Hi,
> As a convert from Access, I need a little help please.
> I need to get a datestamp into a new record when it is created.
> I can see the line for Default Value, but don't know what code to
> insert here.
Default should be:
getDate()
Steve|||Hi Steve,
Many thanks!
NEIL
"Steve" <steve@.somewhere.invalid.com> wrote in message
news:FH6Hd.958160$2W1.74289@.news.easynews.com...
> In news:csisi5$9ge$1$8300dec7@.news.demon.co.uk,
> Neil Jarman <neil@.tNOiSPAMvPLEASEy.co.uk> said:
> Default should be:
> getDate()
> --
> Steve
>

adding a datestamp automatically

Hi,
As a convert from Access, I need a little help please.
I need to get a datestamp into a new record when it is created.
I can see the line for Default Value, but don't know what code to insert
here.
Many thanks,
NEILIn news:csisi5$9ge$1$8300dec7@.news.demon.co.uk,
Neil Jarman <neil@.tNOiSPAMvPLEASEy.co.uk> said:
> Hi,
> As a convert from Access, I need a little help please.
> I need to get a datestamp into a new record when it is created.
> I can see the line for Default Value, but don't know what code to
> insert here.
Default should be:
getDate()
--
Steve|||Hi Steve,
Many thanks!
NEIL
"Steve" <steve@.somewhere.invalid.com> wrote in message
news:FH6Hd.958160$2W1.74289@.news.easynews.com...
> In news:csisi5$9ge$1$8300dec7@.news.demon.co.uk,
> Neil Jarman <neil@.tNOiSPAMvPLEASEy.co.uk> said:
>> Hi,
>> As a convert from Access, I need a little help please.
>> I need to get a datestamp into a new record when it is created.
>> I can see the line for Default Value, but don't know what code to
>> insert here.
> Default should be:
> getDate()
> --
> Steve
>