• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Using Excel via ODBC

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    #11
    If you've got access to SSIS, you should be able to do this straight out of the box.
    The greatest trick the devil ever pulled was convincing the world that he didn't exist

    Comment


      #12
      Originally posted by LondonManc View Post
      My condolences

      Is this to push something to Excel or for Excel to pull from your product?
      Both. Provide an engine with which the user can drive Excel via ODBC
      "He's actually ripped" - Jared Padalecki

      https://youtu.be/l-PUnsCL590?list=PL...dNeCyi9a&t=615

      Comment


        #13
        Originally posted by vetran View Post
        Connecting to an ODBC source Excel should get the data type from the ODBC driver of the DB its connecting to (tabledefs/catalogs) not via its text import crystal ball malarky.


        https://docs.microsoft.com/en-us/sql...ql-server-2017

        https://docs.microsoft.com/en-us/sql...ql-server-2017


        You never ever want Excel to try and guess what data type it is, its wrong more often than a poster in the B***** forum!
        The problem is that if there is no data in the column Excel does not know the datatype it was created as so it assumes it is a varchar. This buggers things up for us as we need to know the column type that it was created as :-(
        "He's actually ripped" - Jared Padalecki

        https://youtu.be/l-PUnsCL590?list=PL...dNeCyi9a&t=615

        Comment


          #14
          Originally posted by MyUserName View Post
          Both. Provide an engine with which the user can drive Excel via ODBC
          Have a read through this; it may help:
          Microsoft SQL Server Integration Services: Mixed data types in Excel column
          The greatest trick the devil ever pulled was convincing the world that he didn't exist

          Comment

          Working...
          X