You might be able to salvage some stuff from Excel. It's hard to say. I
sometimes import and other times copy and paste.

With 450 tabs in 3 files, you have a lot of work ahead of you.

--
Duane Hookom
MS Access MVP
--

"Dave Hoder" wrote in message
...
Thanks Duane!
That's the kick I needed. This started as a one table example that I
whipped
up to show the powers that be what was possible but they insisted on using
Excel. I kept up with the Excel records for a while & have a couple
hundred
records that I'd like to keep. Any way you can see to re-shuffle the data
or
do I need to start over? I don't think importing is an option since the
formatting is a mess (each line of a description on a different row, etc.
THE
HORROR!). They now have 450 tabs on 3 Excel files & they're all a
disaster.