Re: Importing text file into text field

#1

In message <CAA5BE96-E728-4447-B37E-E2CE67172CC3 (AT) microsoft (DOT) com>, VUL
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

I am having problem when importing a text file into SQL Personal
Edition running on Windows 2000 Workstation.
I created a table named "Table1" and a text field name "t". After
importing, here are the problems

1. I do not see the data when import text file size is greater than
1023 bytes
2. Moving the cursor away from the "t" field, sometimes I got a message
"Insufficient key column information for updating and refreshing"

Searched thru Microsoft and made change according to Microsoft
Knowledge Base Article - 814893 and applied Server 2000 SP3 but problem
still existed
Please help.
Thanks
Vul

Sounds like the import is fine. The to issues are down to the display
tool, query analyser perhaps? By default QA limits the number of
characters it displays. This can be increased to about 8000 in the
Options dialog.

Also you don't have a PK on the table, so when you edit the cell, or
just enter it and then move away, which it treats as an edit, the lack
of PK prevents it from generating a suitable update statement under the
covers to pass you changes back to the server.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Importing text file into text field

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Importing text file into text field - 04-18-2004 , 05:37 AM