Databases

  • Thread starter Thread starter cadman29
  • Start date Start date
C

cadman29

Is there any way to create a database with Excel??
I currently use Pc-File to sort and print the contacts to make label
and other reports but I would like to switch to Excel if I can.

Is it possible??

Thanks
Cadman2
 
In Excel, any list of similar values* is treated like a database. It is a flat-file database (not relational), but there are many functions specifically designed to work with this kind of structure (D-formulas such as DSUM, DAVERAGE, DMAX, DMIN, DCOUNT, etc).

*I mean each column contains like data. For example, column A would be Names, B would be States, C would be Amounts, etc.
 
Excel 2002 has a template wizard that allows you to setup
a small database (99 data points) and form for entering
data into that database.
Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel database? 5
About excel & accesse database 1
Creating a pivot table 1
Access Access Report Works on One Machine but not Another 3
Need of a Database for some "basic" info 1
Merge Multiple workbook sheets into one workbook 0
Saving Sort settings 1
Custom Labels 2

Back
Top