Datatypen Notat fejler ved sammenkædning via ODBC med DataFlex

256 characters to be more exact!

Memo fields work fine IN Access but when they are used in other programs then other methods need to be used to read them. They can contain LOTS of data, around 65,000 or more, so you cant just read a memo field as in Access.

You can use the GetChunk method to retrieve a given numbert of bytes from a memo field and then maybe put them in the grid

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthgetchunk.asp

terry ->
Jeg arbejder lidt med dit forslag, men jeg ville gerne se det fulde indhold af feltet i den sammenkædede tabel i Access.

what do you mean by i den "sammenkædede tabel i Access."?

What application are you using to get the data from Access?

I'm using the danish version of access and don't know what it is called in english.

But if you chose the first menu "Filer" and then the second from the top "Get extern data" and then the second from the top again "connect tables??????" or something. Then I use my ODBC data-source to connect to the DataFlex database. In this way I get a link to the table and can see changes in DataFlex "RealTime".

I have two posibilities:
1) Use the method described above
2) Get data into Excel (Visual Basic for applications)

If I use the second option I need to connect to a ODBC data source from Excel. Can I use DAO for this?

Ah!, so it is NOT an Access table/memo field but a field you are linking into Access via a DSN (ODBC) connection!


If you look at the table in design mode (in Access) do you see the field as a memo or just as a text field (255) in length?

The ODBC driver you are using may NOT support all field types!



Have you tried using ADO either in Access or Excel to read data in DataFlex?

If I add a query to a Excel sheet (see below) I get the correct data:

With ActiveSheet.QueryTables.Add(Connection:="ODBC;DRIVER={DataFlex Driver};DBQ=q:\data;SERVER=NotTheServer", Destination:=Range("A1"))
        .CommandText = Array("SELECT ORDRSAG.SAG, ORDRSAG.TEKST" & Chr(13) & "" & Chr(10) & "FROM ORDRSAG ORDRSAG" & Chr(13) & "" & Chr(10) & "WHERE (ORDRSAG.SAG<1000)")
        .Name = "Forespørgsel fra Innoflex"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = True
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .PreserveColumnInfo = True
        .Refresh BackgroundQuery:=False
    End With

From here I can move data into a new Access table with a memo field - it works!

When data changes in DataFlex I need to update my query in Excel, then delete old data in Access, then move updated data from Excel to Access.

This is not the way I want it to work!

Since it is the same data source I'm using, I beleeve it should be posible to get data directly into Access. 

It is still a posibility for me, to get data by ADO or DAO in Excel, but I can not work out how to set up the connection to the data source.

By the way!

The datatype of the field in the connected table is "Notat".

If I use DAO from Excel to insert a long text into the connected table it works. I can insert more than 500 characters and see them from DataFlex. But not the other way around.

It is the same driver and data source I use to read from Excel and from Access.

Jeg har besluttet at benytte nedenstående, som returnerer hele indholdet af feltet tekst. Koden virker både i Excel og Access. Spørgsmål lukkes.

Sub test_conn()

Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset

Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset

Conn.ConnectionString = "data source = 'Innoflex'"
Conn.Open

rs.Open "select tekst from ordrsag where sag = 854", Conn

MsgBox rs!tekst

Conn.Close
Set Conn = Nothing

End Sub