Is it possible......

[PerryG]

to change the field index number of a table programmatically, i.e., change field(2) to field(6)? Seems like you should be able to, but I've never attempted it and I thought I'd ask before I wasted a lot of time (and raised my blood pressure to new heights) trying to do something that is not possible to do.

Thanks in advance to everyone on this forum. You've all saved me a lot of grief on numerous times. You guys ROCK!

PerryG

 

[Ecniv]

No...

Well you could mimic it by opening via an Sql statement and reorganise the fields. But that begs the question why would you want to in the first place..?


Vince

 

[PerryG]

Vince-
It's not what I want, but rather what the powers-that-be require. Actually, it's not really tables, but linked Excel spreadsheets. These files get fed to something large and obscene elsewhere and they have changed the template for the files. I have nearly 1000 files, each with approximately 65k records....hence the desire to automate.

Thanks for the input.

PerryG