Tagged Questions

0
votes
0answers
15 views

what software can I use to show mapping of 2 database?

I have 2 database server main database A and other database B. Database B is same as A but the name of tables and some of the field name are different, but data inside is almost the same. Database B ...
0
votes
0answers
49 views

Time truncation in database results in Excel 2013

We have an application built upon Excel (some querytables plus some VBA). Behind that is an SQL Server query that returns some dates, date part of which is 1899-31-12. This date value is the "zero ...
1
vote
1answer
72 views

Querying variables in Excel

I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type. Here are some ...
1
vote
2answers
463 views

Separate tables or single table with queries?

I'm making an employee information database. I need to handle employees that are separated from the company. Should I a. set up a query with a macro to send separated employees to a separate table, or ...
1
vote
2answers
868 views

Light-weight, free, database query tool for Windows?

My question is very similar to the one here except pertaining to a Windows tool. I am also referencing this table and what I found here with a Google search. However, I have no idea which tool would ...
0
votes
3answers
640 views

Free Database Utilities / Tools for Mac OS X

If I were using Windows and wanted to use a database I would set up a WAMP server. What can I use for Mac OS X? I'm currently using SQLite via Mike's T Sqlite / Firefox addon for SQLite. I would ...