Databases in Excel
Posted by bill.roberts on March 21, 2000 8:57 AM
I do MS ACCESS.
But can someone get me started using DATABASES in EXCEL?
I don't have a clue...
bill
Posted by Tom Morales on March 21, 2000 11:25 AM
Your question is pretty broad. If you're trying to get Access data from an established database, use "data/get external data". You can create a query, or use an existing database's query to extract data from Access into a spreadsheet. From the other direction, using Access, you can also suck in a spreadsheet for use as a dababase table.
That should get you started.
Posted by bill.roberts on March 21, 2000 1:12 PM
Sorry I'm so broad....
Excel comes with an INVOICE document which will store multiple records in what EXCEL calls a DATABASE.
Click FILE/NEW/SPREADSHEET SOLUTIONS/INVOICE.XLT
Once you've cutomized it, you can enter tickets and then flip through the previous ones.
bill
