|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new site built with
SharePoint Designer |
Is Your Database Corrupt ?
See all newsletters
Tips-FX is an email newsletter that provides free tips, help and information for skilled Microsoft Access users and related software disciplines.
Excel to Access - Building a Database Application from Spreadsheets
A
number of the Microsoft Access projects I've been involved in are, in
essence, rescue missions for spreadsheet systems that have outgrown
themselves. These systems share common themes, such as 12 individual monthly
spreadsheets, one yearly spreadsheet that draws the results from the
monthly sheets, and another set of weekly report sheets jumbled into the
system. By the time these interlinked spreadsheets hit their second or
third year, all the monthly spreadsheets have changed in design, and the
old information is only accessible with a lot of manual cutting and
pasting.
This
article that has just appeared in the latest edition of “Microsoft
Office & VBA Developer” tells you how to go about converting from spreadsheets to a
database.
http://www.vb123.com/toolshed/00_docs/excelaccess.htm
-------------------------------------------------------
PREVIOUS EDITIONS OF TIPS-FX
http://www.vb123.com/toolshed/news/toc.htm
Explore
your data visually using our popular Access
data mining shareware
--->
http://www.vb123.com/graf/
View
our web site on your computer rather than the slow
old web and have access to all the software discussed in
the articles and information pages at www.vb123.com
--->
http://www.vb123.com/toolshed/
So
thanks for reading our popular newsletter.
Feel
free to make comments, copy the email to a friend
or maybe even contribute to the next edition.
°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°
Garry
Robinson - Software Consultant
Click on this button
to read the previous edition of Tips-FX
Published 2000-05