dbTalk Databases Forums  

Excel Data not seen in Source Preview

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Excel Data not seen in Source Preview

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


Discuss Excel Data not seen in Source Preview in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
System.Xml.XmlDocument
 
Posts: n/a

Default Excel Data not seen in Source Preview - 03-18-2005 , 08:25 AM






Hi

I have a DTS package where in i am pushing data from Excel to Sql server
database.

When i look at preview of the source (i.e Excel ) in Transform Data link ,
the data from the excel is not shown in VIEW DATA grid.

What could be the reason ?

Regards
Guru

Reply With Quote
  #2  
Old   
Simon Worth
 
Posts: n/a

Default Re: Excel Data not seen in Source Preview - 03-18-2005 , 09:22 AM





Are you using a query or a labeled section within the excel spreadsheet?

Simon Worth

System.Xml.XmlDocument wrote:
Quote:
Hi

I have a DTS package where in i am pushing data from Excel to Sql server
database.

When i look at preview of the source (i.e Excel ) in Transform Data link ,
the data from the excel is not shown in VIEW DATA grid.

What could be the reason ?

Regards
Guru

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top