i am exporting a table from sql server to excel 2003, using dts package.
I want excel sheet should take same field format as in table. But when i
specify the excel file name its takes all fields as varchar.
is there any way to it

Create the Excel table explicitly.

Set cn = CreateObject("ADODB.Connection")

With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" &
DTSGlobalVariables("XL_File").value & "; Extended Properties=Excel 8.0;"
.open
End With

strQuery = "CREATE TABLE `VARIANCE` (" &_
"`OrderNum` Double ," &_
"`VENDOR` VarChar (6) ," &_
"`ITEM_CODE` VarChar (26) ," &_
"`CUST_CODE` VarChar (6) ," &_
"`QTY` Double ," &_
"`PRICE` Double )"

cn.execute strQuery

"Vikram" wrote:

Hello Babe,

You won't be able to use the Wizard because you will need 2 * Source adapters
before going off to XL. Create a new Integration Services project and go
from there.



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com