Graphics

 View Only
  • 1.  Strange Excel Spreadsheet / ADODB Issue

    Posted 06-01-2015 16:07
    I've got a sports roster setup in a spreadsheet, and ALMOST all of the data is can be linked properly except for one issue. I have 30 player rows, followed by 10 rows for player stat graphics. Each row has 3 data columns that are filled with the position/height/weight for the standard supers, and can be filled with statistics for for the stat graphics. Selecting 'Away Team Roster' in Excell verifies that all of the rows and columns are part of the table.

    Data columns 1 and 2 work perfectly for all of the graphics, but Xpressions stops reading Data Column 3 after the final player super and seems to be ignored for the stat supers. If I copy and paste from a Player Super into Player Stat Data3, then the data will appear, but as soon as I type in new information it disappears again.

    Here's how my spreadsheet is laid out and appears in Xpressions.



    Player Super 1 | Linebacker | 5'11"|134

    ...

    Player Super 30 | Linebacker | 5'09"|154

    Player Stat 1 | Stat1.........| Stat2 | (MISSING)



  • 2.  RE: Strange Excel Spreadsheet / ADODB Issue

    Posted 06-01-2015 17:07
    Check the ADODB template you used for configuring the datalinq and make sure you used the one for mixed data; or just add the IMEX=1 onto yours.



    #XPression


  • 3.  RE: Strange Excel Spreadsheet / ADODB Issue

    Posted 06-01-2015 17:25
    I didn't have it set for mixed data, so I fixed that. Unfortunately the problem persists.

    #XPression


  • 4.  RE: Strange Excel Spreadsheet / ADODB Issue

    Posted 06-01-2015 17:27
    Ok, you'll probably need to send the spreadsheet and project to Tech Support for assistance. It's hard to know what could be wrong without actually seeing it.

    #XPression


  • 5.  RE: Strange Excel Spreadsheet / ADODB Issue

    Posted 06-01-2015 17:28
    K. Thanks
    ..........
    #XPression