Access Unlimited - Edition 15

vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

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

The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More

The Toolbox
Libraries of software that we regularly import into our projects. Enhances the Toolshed More..

DryToast New
Backup and query your BaseCamp® projects
Read More

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

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
Contact Us ...

Search ...

or try our Aussie
vb123.com.au
mirror site

Welcome To Tips-FX - Edition 15
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.

In this edition there are only two topics. I hope you find them useful.

-------------------------------------------------------
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.gr-fx.com/graf-fx.htm

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