----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Arian_Intellect Message 5 in Discussion Trying using DTS Shaju Thomas e-Cosmos Technologies Ltd., Mail: [EMAIL PROTECTED] Phone(Off) : 51217038/39 Extn: 132 Mobile: +91 98455 21794 ----- Original Message ----- From: Rajkumar To: BDOTNET Sent: Tuesday, October 14, 2003 4:43 AM Subject: From Excel to Sql server ----------------------------------------------------------- New Message on BDOTNET ----------------------------------------------------------- From: Rajkumar Message 1 in Discussion Hi, I have a excel (Office 2000) file which has two fields. One is numeric primary field and the other is the text field (with some records more then 10000 chars in each cell). I need to import these data's to SQL server 2000. I tried these steps 1. Direct import in SQL server. It gave problem and said that buffer size is low for the second column even though I gave the type as text. 2. Tried to save the excel file as .CSV file and imported from it. It wrote '####' if the field length is more. Same thing in tab delimited format 3. tried to import the data to access and then to SQL. the data trimmed around 255 chars. How can I get the data from this excel file? Any pointers or links is highly appreciated --- n'joy, rajKumar ------------------------ ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED] ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
