database query

  1. W

    Pivot table and pivotcaches not pulling correct data from source.

    Hi. I'm having an intermittant problem with Excel 2010 which for some reason is pulling out a value of #n/a rather than the actual value in the field in the source data: Data Structure/Flow: ----------- Microsoft Access Table 1 -> SQL Database Query -> Excel Workbook A, Sheet 1 Excel Workbook...
  2. A

    the data connection wizard cannot obtain a list of databases from the specified data source error

    I have recently upgraded my machine from Windows XP to Windows 7. I have DB2 and Microsoft 2003 installed in my system. I am trying to create a new database query using Microsoft Query. I have tried out following options so far: 1. Added a data source using Configuration Assistant. I am able to...
  3. Z

    Tracker Question - Looking for a Macro that auto changes cells based cell intersection

    Good Morning, this is my first forum, so please bare with me. I am producing a tracker for some people so that we can track and update any training that we need to complete and know when we need to complete it. What i am looking for is as follows. I a to have a database (I have made already)...
  4. S

    Using Excel as a Database?

    Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’ll try to explain this as best I can… <o:p></o:p> I need to create a database of individuals and their associated team names, location, positions, contact details etc using Excel 2003. Unfortunately we...
  5. C

    Need help in database in excel

    I have a spreadsheet with following columns - User ID Age Height Body type Complexion Diet many other like this I want to create a database such that, For E.g. if someone selects age between 23 to 26 and height 5.6 to 5.9, body type as average, then it should pick all filtered data (as per...
  6. M

    Help! Text and Numbers in database Query from another worksheet?

    Hi - hope someone can help..... I have made a database query to return data from another excel worksheet (all in excel 2003, and on Windows XP) It's fine EXCEPT that some of the columns in the external datasource worksheet contain text rather than numbers. The query returns these as blank while...

Some videos you may like

This Week's Hot Topics