Copyfromrecordset Bug ?
 

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

Copyfromrecordset Bug ?
 

It's a bug: http://support.microsoft.com/default...kb;ja;JP414048
If you are not japanese you should translate it through
http://world.altavista.com/


"news.btx.dtag.de" schrieb im Newsbeitrag
...
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