Hi.
Where I work I've written a somewhat complex database in Access. This
database was to replace what the people were doing in Excel. I'm sure I'm
going to have a hard time getting everyone where I work to switch to my
Database, (I'm sure they will in time) and some will remain with Excel.
Having many people use two different means to input data, I was trying to
link the spreadsheet with the database, but with little luck. I create the
template using the Template Wizard. It reads off the field names in the
database table fine and I assign each excel cell with the proper field name
in Access. It appears all goes fine, and I get the message in the Excel
sheet saying it's linked, but I don't see any of the information from Excel
in Access.
Any ideas?
Any help would be appreciated. It's either this, or I'll have to threaten
everyone with bodily harm if they keep using Excel and not my database. :>
Thanks for your help!
Thom Kirby
thom@cnct.com
...Infinity is one lawyer waiting for another.
--- TAG, You're It!
---------------
* Origin: The Blackboard - Pomona, NY - Since 1983 (1:2625/143)
|