Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

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

Re: Databases in Excel

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.

Re: Databases in Excel

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.