TIP: Click on subject to list as thread! ANSI
echo: win_access
to: ALL
from: THOM KIRBY
date: 1997-01-25 13:27:00
subject: Linking Excel To Access

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.