N
news.btx.dtag.de
Dear all,
I have created an DAO database through Excel :
Set DB = DBEngine.CreateDatabase(DBPath & DBName, dbLangGeneral & ";pwd=",
dbEncrypt)
I have an Table with some memo fields....
If I make an query, all think works fine:
Set rs = DB.OpenRecordset(SQL, dbOpenDynaset)
but with the command:
NumberOfRows = .Range("B2").CopyFromRecordset(rs)
I get the results into the sheet, the failure is that the database-fields
with the memo type,
contains only the first character from the field!!!
Is this a known bug ???
I have searched very long, but don't find any solution and I won't use
ADO...
Regards, Ibrahim
I have created an DAO database through Excel :
Set DB = DBEngine.CreateDatabase(DBPath & DBName, dbLangGeneral & ";pwd=",
dbEncrypt)
I have an Table with some memo fields....
If I make an query, all think works fine:
Set rs = DB.OpenRecordset(SQL, dbOpenDynaset)
but with the command:
NumberOfRows = .Range("B2").CopyFromRecordset(rs)
I get the results into the sheet, the failure is that the database-fields
with the memo type,
contains only the first character from the field!!!
Is this a known bug ???
I have searched very long, but don't find any solution and I won't use
ADO...
Regards, Ibrahim