LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default How do I set up a template & database with Excel 2000/03?

That sounds like an application that would much better be built in Access.
Do you have Access?
You might want to read this article. While it's about VBA, the "Which
application to use" part might give you some insight:
http://www.officearticles.com/misc/p...plications.htm


************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"MissouriRiceFarmer" wrote in
message ...
I am a farmer who uses Excel to record large amounts of information. I
have
a worksheet that I use to record crop types and yield information onto.
How/Can I create a template of this sheet(their will actually be several
copies in the workbook for all the different fields/farms and years) and
have
certain info from each sheet recorded into a database that I can access
when
needed, to view historical trends.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Add-in: Open Database Connectivity available for Excel Nick B Excel Discussion (Misc queries) 8 December 7th 06 06:04 PM
importing links from access to excel to template jwr Links and Linking in Excel 1 February 5th 06 06:42 PM
Email template from excel rlbriley Excel Discussion (Misc queries) 1 March 9th 05 10:16 AM
PLEASE HELP!? Creating a simple database with excel, minor setback Pre-construction Manager & Excel !? Excel Worksheet Functions 1 November 30th 04 08:59 PM
How do I save a record from an excel template to a database in a . Fred Smith Excel Discussion (Misc queries) 1 November 30th 04 01:49 PM


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"