| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO help: Only get first 255 characters of field...
Hi,
can somebody help with this? I have an Access database, that has a table with a memo field in it. This table contains records longer than 255 characters. I am using ADO to get this info out of the database into a recordset, and then loop through the recordset to populate a spreadsheet. However, I only get the first 255 characters for the data that comes from the memo field. How do I get the entire value stored in the database? Somebody mentioned using "adLongVarWChar". But how do I do this? Please help, Thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ADO help: Only get first 255 characters of field...
Make sure that the memo field is the last field selected in your SQL
statement/the last field in the table. Sam " wrote: Hi, can somebody help with this? I have an Access database, that has a table with a memo field in it. This table contains records longer than 255 characters. I am using ADO to get this info out of the database into a recordset, and then loop through the recordset to populate a spreadsheet. However, I only get the first 255 characters for the data that comes from the memo field. How do I get the entire value stored in the database? Somebody mentioned using "adLongVarWChar". But how do I do this? Please help, Thanks, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ADO help: Only get first 255 characters of field...
On 8 May, 14:44, Sam Wilson
wrote: Make sure that the memo field is the last field selected in your SQL statement/the last field in the table. Sam " wrote: Hi, can somebody help with this? I have an Access database, that has a table with a memo field in it. This table contains records longer than 255 characters. I am using ADO *to get this info out of the database into a recordset, and then loop through the recordset to populate a spreadsheet. However, I only get the first 255 characters for the data that comes from the memo field. How do I get the entire value stored in the database? Somebody mentioned using "adLongVarWChar". But how do I do this? Please help, Thanks,- Hide quoted text - - Show quoted text - I have tried this, but it still truncates the field. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use only 2 characters in a field in a formula | Excel Worksheet Functions | |||
| Looking for alpha characters in a field | Excel Worksheet Functions | |||
| automatically copy first 12 characters in one field to another? | Excel Programming | |||
| Removing characters from datetime field | Excel Discussion (Misc queries) | |||
| need to remove last few characters from data in field | Excel Programming | |||
Linear Mode
