7 Replies Latest reply: May 15, 2014 9:52 AM by Louis Angelopoulos RSS

    OpenDatabase Connection String needed!

    Louis Angelopoulos

      Hi all!

      Could someone give me an example of using OpenDatabase on an excel workbook without a password?  I can't figure out the ODBC string.

       

      Thanks!!!

      Louis

        • OpenDatabase Connection String needed!
          Louis Angelopoulos

          Hi all!

          Could someone give me an example of using OpenDatabase on an excel workbook without a password?  I can't figure out the ODBC string.

           

          Thanks!!!

          Louis

          • OpenDatabase Connection String needed!
            Data Kruncher

            Hello and welcome Louis!

             

            You need not get fancy with ODBC connection string as you might when working with ADO or similar programming.

             

            All you really need is the file name, the sheet name where your data resides, and the model file name, as:

            [font="courier"]bSuccess = objMonarch.OpenDatabase("C:Report FilesData File.xls", "", "DataSheet", "C:Report FilesMy Model.xmod")  /font[/quote]Use the "" for the second parameter when a password is not required.

             

            HTH,

            Kruncher

            • OpenDatabase Connection String needed!
              Data Kruncher

              Hello and welcome Louis!

               

              You need not get fancy with ODBC connection string as you might when working with ADO or similar programming.

               

              All you really need is the file name, the sheet name where your data resides, and the model file name, as:

              [font="courier"]bSuccess = objMonarch.OpenDatabase("C:Report FilesData File.xls", "", "DataSheet", "C:Report FilesMy Model.xmod")  /font[/quote]Use the "" for the second parameter when a password is not required.

               

              HTH,

              Kruncher

              • OpenDatabase Connection String needed!
                Louis Angelopoulos

                Originally posted by Data Kruncher:

                Hello and welcome Louis!

                 

                You need not get fancy with ODBC connection string as you might when working with ADO or similar programming.

                 

                All you really need is the file name, the sheet name where your data resides, and the model file name, as:

                [font="courier"]bSuccess = objMonarch.OpenDatabase("C:Report FilesData File.xls", "", "DataSheet", "C:Report FilesMy Model.xmod")  /font[/quote]Use the "" for the second parameter when a password is not required.

                 

                HTH,

                Kruncher /b[/quote]

                • OpenDatabase Connection String needed!
                  Louis Angelopoulos

                  Originally posted by Data Kruncher:

                  Hello and welcome Louis!

                   

                  You need not get fancy with ODBC connection string as you might when working with ADO or similar programming.

                   

                  All you really need is the file name, the sheet name where your data resides, and the model file name, as:

                  [font="courier"]bSuccess = objMonarch.OpenDatabase("C:Report FilesData File.xls", "", "DataSheet", "C:Report FilesMy Model.xmod")  /font[/quote]Use the "" for the second parameter when a password is not required.

                   

                  HTH,

                  Kruncher /b[/quote]

                  • OpenDatabase Connection String needed!
                    Louis Angelopoulos

                    Thanks!  That worked great!!!

                     

                     

                    Originally posted by Data Kruncher:

                    Hello and welcome Louis!

                     

                    You need not get fancy with ODBC connection string as you might when working with ADO or similar programming.

                     

                    All you really need is the file name, the sheet name where your data resides, and the model file name, as:

                    [font="courier"]bSuccess = objMonarch.OpenDatabase("C:Report FilesData File.xls", "", "DataSheet", "C:Report FilesMy Model.xmod")  /font[/quote]Use the "" for the second parameter when a password is not required.

                     

                    HTH,

                    Kruncher /b[/quote]

                    • OpenDatabase Connection String needed!
                      Louis Angelopoulos

                      Thanks!  That worked great!!!

                       

                       

                      Originally posted by Data Kruncher:

                      Hello and welcome Louis!

                       

                      You need not get fancy with ODBC connection string as you might when working with ADO or similar programming.

                       

                      All you really need is the file name, the sheet name where your data resides, and the model file name, as:

                      [font="courier"]bSuccess = objMonarch.OpenDatabase("C:Report FilesData File.xls", "", "DataSheet", "C:Report FilesMy Model.xmod")  /font[/quote]Use the "" for the second parameter when a password is not required.

                       

                      HTH,

                      Kruncher /b[/quote]