data type

  1. B

    change data type of a linked table in access

    I get the below messages in access: Table is a linked table whose design can't be modified. if you want to add or remove field or change their properties or data types you must do so in the source database. I want to change the source data types, how do I do that?
  2. N

    MS Access SQL - data type mismatch

    Hi. While I've been writing Oracle SQL queries for a few years now, I'm relatively new to MS Access SQL. There are surprisingly few resources available online (via Google) for MS Access SQL. Given that, I'm having difficulty figuring out how to format a field which is text as a number (or vice...
  3. D

    Original Fractions in Spreadsheet Don't Convert to Fractions

    Hi guys, I'm having this weird issue in my spreadsheet. I have columns populated with fractions but in excel they are not yet selected as fractions (They are "general"). When I select them and change the data type to fraction, it says its a fraction but there is no change. When I individually...
  4. W

    How to Change Data Type from 1 to 2 (or vice versa)?

    Hi Everyone, I have been trying to join two Excel tables with a Microsoft Query and kept getting the "Type mismatch in expression" error because my data is different types. I tried using Ctrl + 1 to format the cells (text/ general/ number, etc.) but kept getting the error even if they appeared...
  5. R

    MS Access pass-through query for Oracle produces incorrect data type field

    MS Access 2003 Oracle 10g Windows 7 I am basically running data updates every night into local MS Access tables from source data tables in Oracle. This worked fine, until some change on the network which produced a timeout error for all append queries that used pass-through queries. In order...
  6. P

    Which lookup formulas can be used with different types of data?

    Hi all, I'm trying to come up with a simple way to explain to new users in what situations you would use excel's various lookup formulas, to show why it's important to know what format (cross-sectional vs. panel) your datasets are in -- for example, VLOOKUP can be used to pull values from a...
  7. U

    What Data Type do you use for Boolean plus one. True, False and TBD

    I have a complicated routine that I am writing that would normally be Boolean but there are a few times when the answer will be To Be Determined. There are some that are clearly defined with a lot of IF THEN ELSE statements but when all is said and done, there will be three answers. There are a...
  8. F

    What is wrong with my formula code

    Hello all, I'm using the following code to enter a formula into column B which references values in column T: 'Populate Program name column with formulas now referencing values in column-T. Dim ab As Long, c As Long ab = Cells(Rows.Count, "T").End(xlUp).Row For c = 2 To ab Range("B" &...
  9. P

    PowerPivot Show Details creates data table with all fields as TEXT Type regardless of data Type in PowePivot

    I'm new to using PowerPivot but very proficient in Pivot Tables. After I import data from a CSV file into PowerPivot (regardless if data was recognized on import as various types or as all text) I then, column by column, set the Data Types to Decimal, Whole Numbers, Dates, etc as needed and I...
  10. bensonsearch

    VBA Variable type

    Hi All, may be easy but i need a variable type to hold 13 digits in it. I first did long but it aint long enough. It is told hold a barcode.
  11. M

    VBA, ActiveXControls and Data Types

    I am collecting data through an ActiveXcontrol. The command I am using is 'ai = DataqSdk1.GetData'. This data is coming in as type 'variant'. I want to be able to manipulate this data (from counts to a pressure value), but I first need to convert its data type to double. I tried the following...
  12. C

    rota worksheet

    Hi everyone, i dont have in depth knowledge of excel but have been trying to build a rota worksheet from scratch, but i am stuck now. I have a master rota which has everyone's ideal shifts and a weekly rota, i have copied master to weekly so when i put in a time on 1 it updates the other and...
  13. L

    Excel VBA - retrieve Sybase TEXT data type

    I’m having a problem with TEXT Data Type in Sybase. (TEXT is used to store “REMARKS” which may be very long) I have this TEST1 table for testing: create table TEST1 ( DATE datetime, REMARKS text ) [1] I am able to insert some string into the “REMARKS” field but not retrieve it using...
  14. E

    Help With Dates to Text!!!

    I've been looking for answer to this one for awhile. I have a bunch of files with cells that contain a date in the date format (i.e. 10/15/08 stored as "39736" in excel). My task is to create a macro that converts these excel dates to static text in the format yyyy-mm-dd. I've been trying to...

Some videos you may like

This Week's Hot Topics

Top