I have a very specific issue trying to export an excel document into Access
(to convert my spreadsheet to a database). The person who set up the excel
spreadsheet added boxes to check on a list (example, whether an item is code
compliant or not). However, when I bring that document into access (either
by import/export or by copy/paste) the list of items come over, but the check
boxes (and therefore, the actual important data) does not. The only thing I
can think of is to manually recreate each room in Access (basically, start
from scratch). Please note this is NOT desired since I literally have almost
1000 room tabs organized by each building having one excel spreadsheet per
floor (24 buildings, totalling 80 files). For anyone who wants to try, send
me your email, and I'll attach one of these files for you to "play with" to
try to figure it out. You would literally save me weeks of work if you can
figure this out. ANY HELP IS MUCH APPRECIATED!!!

What version of Excel? What version of Access?

I could take a look in a couple of days (I'm up to here -- in a critical
import routine).
Won't promise anything.....

Please zip it before sending..

Here is my junk email...

91898472
@at@
techie
....dot....
com

Put it together correctly to make the email address.

--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"Heather Bishop" wrote:

> I have a very specific issue trying to export an excel document into Access
> (to convert my spreadsheet to a database). The person who set up the excel
> spreadsheet added boxes to check on a list (example, whether an item is code
> compliant or not). However, when I bring that document into access (either
> by import/export or by copy/paste) the list of items come over, but the check
> boxes (and therefore, the actual important data) does not. The only thing I
> can think of is to manually recreate each room in Access (basically, start
> from scratch). Please note this is NOT desired since I literally have almost
> 1000 room tabs organized by each building having one excel spreadsheet per
> floor (24 buildings, totalling 80 files). For anyone who wants to try, send
> me your email, and I'll attach one of these files for you to "play with" to
> try to figure it out. You would literally save me weeks of work if you can
> figure this out. ANY HELP IS MUCH APPRECIATED!!!