|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Extracting data from Excel Posted by Schnof at 4/29/2005 9:37:42 PM HI,
Can anyone tell what I'm missing to be able save an excel workbook to
text format using dts.
Excel_WorkBook.SaveAs "E:\EXcelData\rabbit.txt"
Which save's it fine , but I need to be able to set the format for this
to be done properly
Regards
Andrew...more >>
bcp Posted by Hoosbruin at 4/29/2005 6:20:40 PM
I'm using BCP with queryout and exporting data from a table to a .csv file.
Using this as a template it works fine but is there anyway to get the column
headings along with the data. I'm using this method because I can create
different output filenames. I have a DTS to do this but I can't ...more >>
When importing text file, order of lines are all messed up Posted by pelican at 4/29/2005 2:36:01 PM Hello everyone,
I am using the "import" function in SQL to import a big text file to SQL.
It will import all the lines, except that starting from line 989, it just to
a line way down at the bottom of the text file, line 70987. Isn't it
strange? I thought the import function will read fro...more >>
SMTP in my database server Posted by Ray5531 at 4/29/2005 2:11:06 PM I basically need to send emails from MY DTS packages and also some of my
stored procedures.There is no way of having any MAPI compliant software
installed on the productions database server,so I came up with the idea of
installing an SMTP server and use the extended stored procedure introduced
h...more >>
import data from Excel Posted by Ava at 4/29/2005 12:14:04 PM I have mixed data in one Excel column (integer and string). If the integers
on the top I can only import integers and all string values will be NULL. If
the string values on the top I can only import strings but the integers will
be NULL. Is there any way to import mixed data?
Thanks for any ...more >>
increament primary key when reading each line of text Posted by pelican at 4/29/2005 11:46:06 AM Hello,
I have a text file that needs to be read into SQL. I can read the file
alright, but I have problems adding a primary key to the SQL table and make
it increament automatically. If I read the text file into a new table, the
primary key is not created. If I created an empty table and...more >>
import text file with long strings Posted by pelican at 4/29/2005 9:04:02 AM Hi!
I have a text file over 70000 lines, some lines are long some are short.
I tried to import this text file into SQL, but all it did was to take the
shortest line as the width and truncated the long times. Though I have in
the "transform" to change the field to varchar and length to 100...more >>
DTS file import Posted by hector.caban NO[at]SPAM gmail.com at 4/29/2005 7:49:54 AM Hello everyone,
I am importing a flat file using dts. I notice that if there is an
error in the file, the transactions are rolled back. I need to import
each row as a transaction in itself. How do I do that ?
For example if the There are 2000 rows and 1 row is bad then 1999 rows
should be impor...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Excel Export, 255 Char Truncation and Destination Column Definitions Posted by alasdair at 4/29/2005 3:11:56 AM I have a DTS package which exports from a SQL table to an Excel
spreadsheet - nothing tricky so far. The (SQL Server) source table
contains several columns which have more than 255 chars of data. When I
created the destination worksheet in DTS Designer, I specified LongText
as the data type for ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |