Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fireloard
Starting Member
23 Posts |
 Posted - 2006-05-02 : 14:57:13
|
| Ok i'm pulling data out of an access data field of type Memo and trying to put it into a SQL Server field of type text. It truncates the data at 256 characters and I can't seem to find any options to get it to do all the text. I searched the forum and Google but all I found was a registry update/hack for Excel that doesn't seem to do anything. In the same HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0 I tried to change the MaxBufferSize for Jet 4.0 but that didn't seem to change anything. Does anyone have any idea how I could get the full memo field from the access database into the text field of the SQL database? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-02 : 21:16:29
|
| how do you know it only saves 256 characters?just curious how you verified the saved data, if QA, you might be seeing a limit on QA view, you can extend this under Tools-->Options-->Editor tabHTH--------------------keeping it simple... |
 |
|
|
fireloard
Starting Member
23 Posts |
Posted - 2006-05-03 : 09:22:15
|
quote:
Originally posted by jen
how do you know it only saves 256 characters?just curious how you verified the saved data, if QA, you might be seeing a limit on QA view, you can extend this under Tools-->Options-->Editor tabHTH--------------------keeping it simple...
That worked. Thanks... I wasted a bunch of time looking for a problem that wasn't even a problem. edit: I guess thats happened to everyone at least once. |
|
|
|
|
|
|
Access to SQL Server column limit.