Wanted-simple advice re. correct database format??

ATP_1

Distinguished
Jul 20, 2009
39
0
18,580
0
I am trying to build a searchable database with multiple criteria with Excel (2003). However, while my initial research provides me tutorials on how to do this, I am unsure of where it is no longer feasible with Excel, & then time to build with other technology.

I do not wish to spend precious time on attempting this with Excel only to find that it would have been better at the outset to proceed with other technology.

Anyone here oblige me on how to resolve this issue? For example, help me determine what the correct nature of my problem is, then direct me to where I ought to go for assistance, if not here in this forum or site??

Thanks very much.

 

randomizer

Distinguished
Jul 24, 2006
880
0
19,260
62
You can use an excel spreadsheet as a pseudo-database. However, it's not very efficient and probably a bit unweildy, so you would only want to do so if for some strange reason you needed some Excel-specific functionality and/or you are working with a relatively small dataset and queries that aren't overly complex.

The problem with your question is that you are asking what technology you should be using without really describing what you want to do. You could build a "searchable database" with CSV files if you wanted to. That doesn't mean it's a good (or bad for that matter) idea. Subject to additional information, I'd still lean heavily towards a "proper" database backend such as MySQL, PostgreSQL or MSSQL purely because they are immensely more scalable than a spreadsheet. After all, querying data is what they're built for.
 

randomizer

Distinguished
Jul 24, 2006
880
0
19,260
62
You can use an excel spreadsheet as a pseudo-database. However, it's not very efficient and probably a bit unweildy, so you would only want to do so if for some strange reason you needed some Excel-specific functionality and/or you are working with a relatively small dataset and queries that aren't overly complex.

The problem with your question is that you are asking what technology you should be using without really describing what you want to do. You could build a "searchable database" with CSV files if you wanted to. That doesn't mean it's a good (or bad for that matter) idea. Subject to additional information, I'd still lean heavily towards a "proper" database backend such as MySQL, PostgreSQL or MSSQL purely because they are immensely more scalable than a spreadsheet. After all, querying data is what they're built for.
 

PhilFrisbie

Distinguished
Apr 22, 2006
666
0
19,310
53

Access might be a good choice as long as the OP does not intend to connect it to a web page for queries. Access gets corrupted easily in a multi-user environment.
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 0
N Apps General Discussion 1
D Apps General Discussion 3
M Apps General Discussion 1
J Apps General Discussion 1
S Apps General Discussion 1
J Apps General Discussion 1
K Apps General Discussion 1
M Apps General Discussion 1
G Apps General Discussion 0
A Apps General Discussion 2
K Apps General Discussion 2
K Apps General Discussion 2
T Apps General Discussion 7
L Apps General Discussion 1
A Apps General Discussion 4
anustarique Apps General Discussion 3
B Apps General Discussion 1
P Apps General Discussion 3
P Apps General Discussion 1
Similar threads
Question Want a simple bare-bones online backup solution
Solved! Want to download podcasts to mobile device without using data or WiFi
How do I find a scammer's location with skype? He scammed thousands of dollars from me and I want to call police in that area
Solved! I lost my remote control for my Vizio TV so I want to use my smart phone to change the channel on my phone
I just publish a video and went to veiw it it was getting ready to play then it said play back error please help me i want to
I want to get app to clear hackers from my I phone 6
Deleting Yahoo I want to search
In engineering simulations, we often want to generate a floating-point sequence of values with a specified mean and variance.
I want to install "Al Qur'an" in open office writer. I have the link from http://code.google.com/p/qioo/downloads/list, they
The Marvel Cinematic Universe Movies We Want Next
Hi everybody! I want to find a doc not saved but printed in November 2016, more than 1 year. It's that possible? Thank you!
Going from Amazon 7th generation to Amazon 10.1, how do I import my current games from one to the other? I don't want to lose
I have a perl application which is running of 4.2. Now we want to upgrade it to the latest version. I need suggestions over th
i need an application to keep track of giveaways (and things that i want to remember)
i have a messenger on my laptop, i want to clone it. so that i can have dual account on the laptop. how do i do it?
What is the best gpu for an pentium4 pc i want to use it for video addition and heavy duty recording apps?
Jquery Queation Want Help
For this first week, I am going to be super nice and just give you the definitions of the classes. What I want you to focus o
I want to use WMP on Windows 7 and vLC pops up and don't like the big black ugly screen
I want to download my whattsapp

ASK THE COMMUNITY