View Single Post
  #6  
Old May 19th 05, 02:27 AM
Tom Jackson
external usenet poster
 
Posts: n/a
Default

Probably the easiest thing to do, if you need a quick fix, is to enter all
of your information into an Excel spreadsheet, in a logical "database-like"
format - i.e., each column represents a field, each row represents a record.

The Excel spreadsheet can be very easily imported (or linked) into your
Access database where you can design a prettier front-end (i.e., a "form"
and/or "reports" for viewing, data entry, reporting, etc.)

In fact, you can actually maintain the data in the Excel spreadsheet while
you work on the Access formatting if you "link" to the Excel data. This
way, you can keep the data current and useful, if not really "pretty", while
you design the Access elements.

Once you are satisfied with the design, you could then import the data into
Access (as opposed to linking to Excel) and maintain it as simply an Access
DB going forward.


"Blanche" wrote in message
...
I use Excel. Sort on any column, does what I need, which is
being able to search for a specific word or phrase when I
need to determine if/when something was done, e.g. ADs.