H
Heather Bishop
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!!!
(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!!!