LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Excel Database


On its way. Thanks a bunch.

Bernie Deitrick wrote:
Frank,

If you want to use Excel as a database, then enter your data into a
database: one sheet of one workbook, with all the information that you need,
and all the fields by which you you want to isolate data. (Excel isn't a
relational database, but you can use multiple databases if the information
isn't well related, like one for personal data like addresses, and another
for your actual data) Then you can use data filters to show / extract the
information that you want. Forget about using multiple workbooks - they
just make things harder.

HTH,
Bernie
MS Excel MVP

Hello. I need to be able to access data from Jan. '04 into the future from
a

[quoted text clipped - 21 lines]

Thanks,



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200508/1
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel Database via Access Main Database with a script Finnbar New Users to Excel 2 November 3rd 08 07:24 PM
Convert Excel database to dBASE database? RPI Marketeer Excel Discussion (Misc queries) 1 January 18th 08 06:25 PM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
How to make reference to database and if true copy from database? V!p3r Excel Discussion (Misc queries) 4 February 5th 07 02:19 PM
Moved database, how do I change link to the database in excel Toastrack Excel Discussion (Misc queries) 0 October 20th 06 09:36 AM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"