Graphics

 View Only

  • 1.  Datalinq not importing all the data from excel file

    Posted 20 days ago
      |   view attached

    I have a datalinq linked to an excel file. Some of the fields have bullets points of data. Thing is its working for most of the info but in some circumstances its only showing for instance 7 out of the 12 bullet points, and in that line 7 its half the sentence. Any suggestions?



    ------------------------------
    David Rock
    ------------------------------


  • 2.  RE: Datalinq not importing all the data from excel file

    Posted 20 days ago

    Hey David,

    Did you browse the data in Datalinq to see if all the bullets are actually showing?

    If so, could this be a character limit issue in the text field that is linked?



    ------------------------------
    Paulo Dias
    ------------------------------



  • 3.  RE: Datalinq not importing all the data from excel file

    Posted 19 days ago

    Thanks....I did browse the data in Datalinq and it is cut mid-sentence. Any other suggestions?



    ------------------------------
    David Rock
    ------------------------------

    Original Message


  • 4.  RE: Datalinq not importing all the data from excel file

    Posted 16 days ago

    Hey David, maybe Datalinqed fields have some type of character limit (which I didn't know of).

    Maybe you could create a text field for each bullet.



    ------------------------------
    Paulo Dias
    ------------------------------

    Original Message


  • 5.  RE: Datalinq not importing all the data from excel file

    Posted 12 days ago

    This is a decade old bug in the Microsoft ACE driver for data.
    The max characters being sent from Excel is maxing out at 255 characters (exactly like in your image).

    To increase the maximum you need to put more than 255 characters in the first row of the column you are getting data from. Then all the following rows will have their max character count increased. 

    It sounds silly but that's what it is.

    -------------------------------------------



  • 6.  RE: Datalinq not importing all the data from excel file

    Posted 11 days ago

    I remember from a long time ago there was also an edit in the Windows Registry to fix this. Sadly I can't find this edit any more. Perhaps someone with a better archive can have a look?



    ------------------------------
    Rob van Rooyen
    NEP GROUP INC.
    Hilversum Netherlands
    ------------------------------

    Original Message


  • 7.  RE: Datalinq not importing all the data from excel file

    Posted 7 days ago

    Thanks all. I ended up just taking out some of the information. This is good info for the next time.....thanks again.



    ------------------------------
    David Rock
    ------------------------------

    Original Message