SQLSolutions and SSIS

Wednesday, May 22, 2013

Issue - Read Excel using OLEDB only reads 255 characters

Need to make the Following changes in registry

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engine\Excel

TypeGuessRows should be changed to 0
Posted by MySql at 3:28 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (3)
    • ►  July (3)
  • ►  2014 (24)
    • ►  December (2)
    • ►  November (2)
    • ►  September (1)
    • ►  August (1)
    • ►  April (1)
    • ►  March (8)
    • ►  February (1)
    • ►  January (8)
  • ▼  2013 (123)
    • ►  December (20)
    • ►  November (1)
    • ►  October (8)
    • ►  September (48)
    • ►  July (7)
    • ►  June (10)
    • ▼  May (11)
      • SQL SERVER – Simple Example of Recursive CTE
      • Add Identity Column to Table Based on Order of Ano...
      • SSRS - Creating basic Report
      • INSERT data from Stored Procedure to Table
      • Top 20 exciting features of SQL Server 2012
      • Change Data Capture (CDC) in sql server 2008
      • Change Tracking feature in SQL Server 2008
      • Issue - Read Excel using OLEDB only reads 255 char...
      • Red Gate - SQL Doc
      • Multiple Tables in Update/Delete Statement
      • Convert rows into comma separated values with grou...
    • ►  April (16)
    • ►  January (2)
  • ►  2012 (1)
    • ►  December (1)

About Me

MySql
View my complete profile
Awesome Inc. theme. Powered by Blogger.