MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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