Tag Info

New answers tagged

0

I would use the Power Pivot Add-In for this. It has a rich functional syntax (in particular CALCULATE) which I expect would be capable of all of those requirements. The output presentation would be Excel Pivot Tables and Charts, based on the Excel Data Model with calculations that you develop in Power Pivot. ...


0

You can definitely do all of this in Excel with VBA - the application used depends entirely on what you need. Some things to consider: If you will have multiple clients (Excel applications) that are going to get and post data you'll be better off with having the data in an actual database, though you can use Excel for this too. If it's only the one ...


1

MySQL dumps are only meaningful when restored into an actual database. The only integrity you could check over a dump is SQL syntax. But there is nothing you can do about the data. Usually database administrators will restore a random backup into a database and check the restore process works fine. Of course you have to do it at least one time when you ...


1

Your case is exactly like I had couple months ago. I also try to build SQL query in my head every time I need to do some manipulate with data in Excel. So, I have created a little Add-In called XLTools SQL Queries. Now I have published it on our website for others like you and me! It allows to build any SQL query against tables in Excel workbook(s) using ...


0

As always with performing a repair like this, I recommend that you first make at least one backup copy of your places.sqlite file located in your profile directory. Having a backup allows you to try various different things to repair such problems while knowing that if the attempted repair makes things worse, you can always make another copy of the backup on ...


0

To be able to logon to a SQL Server instance, you have to know what you did during the installation. The SQL Server instance name is specified here. Did you select the default, or you specified a name for it? 2.What about the authentication type and SQL Server as account login? 3.When you start SQL Server Management Studio, in the Server name list ...


3

Excel stores a copy of the queried data in the spreadsheet. You can set an option whether you want it to refresh on load, or only upon some manual intervention or VBA-based event. You can use Excel query data the same as you would any other data in Excel. In the absolute worst case, if there is some kind of limitation, you could copy your queried data to a ...


0

Your inconsistent use of the semi-colon to delimit your commands would be (at least part of) your problem. You need one at the end of each command. :) Open cur1 is a stand-alone command that should have a ; after it (as should your "Print" statement). Since it doesn't, then MySQL will interpret the two lines as a single command: OPEN cur1 FETCH NEXT FROM ...


0

You are correct, from the schema spec, you cannot. you would have to denormalize the Course_Fee table, so that it also appears in the Student_course table (as that is the only table that maps 1-to-1 with the phenoma of a specific student taking a specific class. ) There is an alternative however. Imagine in the Course table you had two rows like: ... ...


0

This means you have incorrectly set up environment variables. You would have to share more details about the box, like if there are any Oracle products already installed, your Xsh profile, etc, but basically: If you are about to work with one product, you need your ORACLE_HOME, ORACLE_SID and also PATH having pointing same Oracle home. What you mention is ...


0

It's pretty easy, actually. First you edit ../response/db_install.rsp file to define your desired settings and then you run ./runInstaller -silent [-waitforcompletion] -responseFile ../response/db_install.rsp. On the first look it may seem like a lot of editing but for plain install only a few parameters need to be changed. This is the best way how to make ...


0

You installed SQL Server. This is the local DB server that you need running. With regard to the authentication, if you are connecting to a server on your local machine then you use Windows authentication which takes your windows user/pass to login to the db. If you are connecting to a server that is not in your network/on your local machine then you use ...


0

In this case, you can run select * from sys.databases To check the databases that exist in your SQL Server instance. If the database exists, check its state_desc column value, it might not be online. Then, run the following to see where its files are located: SELECT type_desc, name, physical_name FROM sys.master_files WHERE database_id = ...


1

When i type psql template1 and then tab, i don't get the user "myuser" and don't know why. It's bash programmable completion feature which is at play here. It appears that for psql, tab does not suggest a list of user names on the command line when the cursor is after a database name. If does produces that list however, when the cursor is after -U. ...


1

Commits will queue up and all flush when the WAL gets written. So you'll get big groups of commits writing 5 times a second.


2

If you were using Windows you could use picasa from picasa.google.com. Pictures can be tagged with whatever you want and you can search based on those tags. Option 2: galleryproject.org It is web based and has a mysql database, but the gui is simple. You can tag pictures and search on those tags. There are addons/extension for additional functionality. ...


1

Since you don't mention where do you want to implement your database, I assume you're doing this for a website, the approach I've been using is as follows: Let's say that I have a directory with 100 pictures, each one named in order: 1.png 2.png 3.png … 100.png So I construct a database which stores such images information in the colums as follows: id, ...


2

My first thought is that you don't... place pictures in a directory and you can store links to the files, tags, etc in the database.


0

It looks like the user doesn't actually exist. Try using adduser test to create the passwd entry


1

With your model open (this is required, as the navigation menus are context-aware), choose either "Synchronize Model" or "Synchronize with Any Source" under "Database".


0

MS Access: There is a tutorial at http://databasesuperstar.com/ms-access-tutorial-how-to-import-csv-file/, which is very good quality and too much to reproduce here. OpenOffice: From https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=37013 (source: various users), which presents multiple good options: Import the CSV data into Calc. Select ...


0

.db is used for several differant formats, but I'm assuming you mean Access. you can use the Access data import wizard to load the csv into a table. Instructions here: http://databasesuperstar.com/ms-access-tutorial-how-to-import-csv-file/ for OpenOffice, see here: https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=37013


2

I would use the Power Query Add-In for Excel to tackle this. It can handle appending results from a SQL query to an existing table. http://office.microsoft.com/en-au/excel-help/append-queries-HA104149760.aspx?CTT=5&origin=HA103993872 If you store the data in the Excel Data Model format (not in an Excel Table), the data is highly compressed - there are ...



Top 50 recent answers are included