Hi,
I dont use the QA and i viewing the data in the tables. I have count the
characters and they are cut off at 255 characters.
In the Access Database i can see the whole text but when the data is
migrated, the text is cut off.
I use the DTS importer to create a dts File, when i open it to change the
"Fastupload" i can use the preview an i see that the text is cut off.
There is maybe a hook to be change but i dont know where. =)
Dawid
[quoted text, click to view] "AlterEgo" wrote:
> Dawid,
>
> How do you know the data is getting truncated at 255 characters? Is it
> because you are viewing it in a QA grid? If so, maybe the grid is truncating
> the data, but the data is fine. Click Tools/Options/Results and look at the
> Maximum characters per column setting.
>
> -- Bill
>
> "Dawid" <Dawid@discussions.microsoft.com> wrote in message
> news:F5881110-218C-4786-B1DE-28EE4B51D7B9@microsoft.com...
> > Morning!
> >
> > I have a little Problem with the import Wizard.
> > The situation is a Access DB with a memo field in wich are very long text.
> > And i migrate this DB into a SQL Database wich has a field for this memo
> > filed. I hae declared this field with a ntext type.
> > And now when i import the db, the Wizard cut off the Text at 255
> > characters
> > and i dont know what to do.
> >
> > Can someone help me or have the same problem?
> >
> > Dawid
>
>
Dawid,
What datatype is the SQL Server column in the table you are importing into?
It should be either "text" or "ntext".
-- Bill
[quoted text, click to view] "Dawid" <Dawid@discussions.microsoft.com> wrote in message
news:91F773E1-604F-4A88-831F-0C288C64CFEE@microsoft.com...
> Hi,
>
> I dont use the QA and i viewing the data in the tables. I have count the
> characters and they are cut off at 255 characters.
> In the Access Database i can see the whole text but when the data is
> migrated, the text is cut off.
> I use the DTS importer to create a dts File, when i open it to change the
> "Fastupload" i can use the preview an i see that the text is cut off.
> There is maybe a hook to be change but i dont know where. =)
>
> Dawid
>
> "AlterEgo" wrote:
>
>> Dawid,
>>
>> How do you know the data is getting truncated at 255 characters? Is it
>> because you are viewing it in a QA grid? If so, maybe the grid is
>> truncating
>> the data, but the data is fine. Click Tools/Options/Results and look at
>> the
>> Maximum characters per column setting.
>>
>> -- Bill
>>
>> "Dawid" <Dawid@discussions.microsoft.com> wrote in message
>> news:F5881110-218C-4786-B1DE-28EE4B51D7B9@microsoft.com...
>> > Morning!
>> >
>> > I have a little Problem with the import Wizard.
>> > The situation is a Access DB with a memo field in wich are very long
>> > text.
>> > And i migrate this DB into a SQL Database wich has a field for this
>> > memo
>> > filed. I hae declared this field with a ntext type.
>> > And now when i import the db, the Wizard cut off the Text at 255
>> > characters
>> > and i dont know what to do.
>> >
>> > Can someone help me or have the same problem?
>> >
>> > Dawid
>>
>>
>>
