Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Sample for Oracle-to-Excel extraction with CopyFromRecordset | Excel Discussion (Misc queries) | |||
CopyFromRecordset Problem | Excel Discussion (Misc queries) | |||
Format data in Excel after using copyfromrecordset | Excel Discussion (Misc queries) |