Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use row-numbers for export

Status
Not open for further replies.

Quasibobo

Programmer
Oct 11, 2001
168
NL
Hi,

Is it possible to use the row-numbers from an Excel-sheet?
I'd like to have a unique id (like auto_increment in SQL), so why not use the row-numbers? I need those numbers for an export...

Is that possible? (Otherwise I need to add another column with the numbers 1 to ...., but when you look at it.... this column IS already there!)

T.I.A.

Quasibobo

Don't eat yellow snow!
 
Quasibobo .... no, the column ISN'T already there, the headings are not part of the data, they are just there to show you where abouts in the data you are. Add another column like you said.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Ok.... I'll go with the ROW()-function!

Don't eat yellow snow!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top