Forum Discussion
SQL Spreadsheet
Hello everyone, We would like to ask the following question on the use of SQL. Please apologize for having not much knowledge yet on this topic. We are still beginners and eager to learn, and there...
- Can we find a way to apply SQL operation to this table (spreadsheet)?
Joonam123 , sorry, but for me it's not clear, what you trying to achieve here?
Yes, the ACE OleDB Provider for Excel support a sub-set of SQL command. But even if it's said, Excel is the largest database in the world; it isn't a real database, it's a spreadsheet.
Why not using real databases supporting full SQL like MS SQL, MySQL, SQLite etc?
Meanwhile you get free but small databases in the cloud, where everyone of your team can access it.
Olaf
Thanks. This sounds really good. So let me ask you from another angle: We want to set up a DB for the 3 of us, but we dont have not enough knowledge but would like to learn it. Thus: We would like to start learning how to use and start using a "real database" 1. Where is this "free and small database in the cloud" with which we could start. 2. We would prefer a cloud database system with a good tutorial so that we can learn to set up a DB and utililizing it step by step. And if the costs are not super high, we will be of course happy to pay for this as well.