Question Numbering each Excel Import

[pascaly]

I have a need to do multiple imports from Excel each week, each import needs to be individually identifiable. Is there a way to create a unique ID for each import I do (as opposed to each record).

Thanks.

 

[pbaldy]

You mean in a field in the table the data is imported into? You could add a field and use DMax() to get the highest value in that field, and add one for the current import.

 

[pascaly]

Hi Paul,

yes, sorry, I should have been more clear, I mean into the table I'm importing to.

Thanks for the tip, I'll give Dmax a try. Much appreciated.

 

[pbaldy]

No problem, post back if you get stuck.