12 {{ upvoteCount | shortNum }}
12 {{ upvoteCount | shortNum }}

Database, is this possible?

by 1963jag
12 replies
I need a database that can pull data from multiple Excel pages, and then be used to populate sections of a financial report in Word.

I can provide samples of the typical Excel files and financial report.


Database will be used to create multiple reports monthly and potentially have widespread demand in the
niche (according to my client)

Secondly, this project also requires an application (?) that would facilitate the quick movement of data from an Excel file with multiple sheets, to a Word doc.
Problem, the Excel pages, tabs etc. are never the same from job to job.
There would need to be some options available to the end user to allow customizing of the specific reports being produced in Word.



I want to know if A) such a project is possible, and B)if it can be built for a user (not a coder) to operate, in other words
elegantly and without clutter and an operating manual two inches thick.


Are YOU talented and highly skilled at programming such projects?


We should talk.
#database #excel #project
  • Profile picture of the author David Beroff
    Sure, this is possible. It sounds like a fun project. I assume that the Excel files will always be provided in an identical format? Or...?
    Signature
    Put MY voice on YOUR video: AwesomeAmericanAudio.com
    {{ DiscussionBoard.errors[10432493].message }}
    • Profile picture of the author 1963jag
      Originally Posted by David Beroff View Post

      Sure, this is possible. It sounds like a fun project. I assume that the Excel files will always be provided in an identical format? Or...?
      David,
      are you interested in knowing more about this project?

      Can you tell me about your skill set as well please?
      {{ DiscussionBoard.errors[10450710].message }}
      • Profile picture of the author David Beroff
        Originally Posted by 1963jag View Post

        David,
        are you interested in knowing more about this project?

        Can you tell me about your skill set as well please?
        Yeah, sure. I've been writing software for four decades, since I was 11, and taught Computer Science at Rutgers University when I was 18. My current software project is designing and maintaining the MySQL database and backend website for the 500+ Members of an American investment firm. I'm responsible for managing the 27 tables and 37k transactions that represent the US$15M corporate portfolio.
        Signature
        Put MY voice on YOUR video: AwesomeAmericanAudio.com
        {{ DiscussionBoard.errors[10450723].message }}
        • Profile picture of the author Joe Ray
          Originally Posted by David Beroff View Post

          Yeah, sure. I've been writing software for four decades, since I was 11
          You said in your post that you've been "writing software for four decades". You mean in 1975? You wrote software in 1975 and you were 11 years old? Are you kidding?
          Signature

          {{ DiscussionBoard.errors[10455366].message }}
          • Profile picture of the author David Beroff
            Originally Posted by Joe Ray View Post

            You said in your post that you've been "writing software for four decades". You mean in 1975? You wrote software in 1975 and you were 11 years old? Are you kidding?
            No, I'm not kidding. I had access to a corporate mainframe that included a BASIC interpreter. My high school had a similar setup. I had a Texas Instruments programmable calculator, with a magnetic strip that could store a whopping 256 instructions. Later, a friend let me borrow a TRS-80, and I figured out how to get it to play sounds with the help of an AM radio next to the processor. There were also pencil-and-paper "devices", such as Turing machines and Bell Labs' Cardiac simulator.
            Signature
            Put MY voice on YOUR video: AwesomeAmericanAudio.com
            {{ DiscussionBoard.errors[10455747].message }}
            • Profile picture of the author Joe Ray
              Originally Posted by David Beroff View Post

              No, I'm not kidding. I had access to a corporate mainframe that included a BASIC interpreter. My high school had a similar setup. I had a Texas Instruments programmable calculator, with a magnetic strip that could store a whopping 256 instructions. Later, a friend let me borrow a TRS-80, and I figured out how to get it to play sounds with the help of an AM radio next to the processor. There were also pencil-and-paper "devices", such as Turing machines and Bell Labs' Cardiac simulator.
              You had access???? to a corporate mainframe in 1975 when you were 11 years old and you just magically started writing software on this somehow . Oh, I forgot you were in high school already at the age of 11 where they had access to an other corporate mainframe somehow, so you probably thought yourself how to write software there so you can get prepared to start teaching computer science at a Rutgers University 7 years later, when you turned 18, as you mentioned in your previous post.

              What can I say... No comment.
              Signature

              {{ DiscussionBoard.errors[10456278].message }}
              • Profile picture of the author David Beroff
                Originally Posted by Joe Ray View Post

                You had access???? to a corporate mainframe in 1975 when you were 11 years old and you just magically started writing software on this somehow . Oh, I forgot you were in high school already at the age of 11 where they had access to an other corporate mainframe somehow, so you probably thought yourself how to write software there so you can get prepared to start teaching computer science at a Rutgers University 7 years later, when you turned 18, as you mentioned in your previous post.

                What can I say... No comment.
                Now you see why I normally don't bother giving my personal history. There was no magic, and I condensed a few years of history into a single paragraph. I graduated high school at 15, and college at 19. I taught for two semesters in 1983; I got the job because they were in a real bind, (no one could understand a word spoken by the person originally hired for the job), and I was able to take the position with essentially zero notice. The corporate access was originally gained by "borrowing" credentials from a family member, but I ended up contributing to the project at hand, so eventually that transitioned into a paid position.
                Signature
                Put MY voice on YOUR video: AwesomeAmericanAudio.com
                {{ DiscussionBoard.errors[10456295].message }}
  • Profile picture of the author Joe Ray
    Yes, this can be done. I can do this for you. Please PM me more details so can take a look.
    Signature

    {{ DiscussionBoard.errors[10433383].message }}
  • Profile picture of the author Yadav Poonam
    It's a very simple job for my team as we have done these kinds of work before.
    {{ DiscussionBoard.errors[10434212].message }}
  • Profile picture of the author yukon
    Banned
    Originally Posted by 1963jag View Post

    I need a database that can pull data from multiple Excel pages, and then be used to populate sections of a financial report in Word.

    I can provide samples of the typical Excel files and financial report.


    Database will be used to create multiple reports monthly and potentially have widespread demand in the
    niche (according to my client)

    Secondly, this project also requires an application (?) that would facilitate the quick movement of data from an Excel file with multiple sheets, to a Word doc.
    Problem, the Excel pages, tabs etc. are never the same from job to job.
    There would need to be some options available to the end user to allow customizing of the specific reports being produced in Word.



    I want to know if A) such a project is possible, and B)if it can be built for a user (not a coder) to operate, in other words
    elegantly and without clutter and an operating manual two inches thick.


    Are YOU talented and highly skilled at programming such projects?


    We should talk.


    That could be done with VB.net & multiple datagrids. Just use CSV files for the content & it's basic tabs or commas for separating the column data. Assuming you're looking for an offline Windows desktop app.
    {{ DiscussionBoard.errors[10450738].message }}
  • Profile picture of the author PeachCoding
    What you want can be done either in Visual C# with MS SQL as the database either as a desktop or web based application; or in PHP w/MySQL as the database. And the fact that the tabs (sheets) in the excel sheets won't be in the same place will make it a bit harder but nothing out of the ordinary that can't be handled by an experienced programmer.

    I definitely have the experience to build this project and have worked on both languages C# and PHP on many other projects. And I'm available to talk here via PM or via email if you're still looking to build this project.

    Hope that helps.
    Signature

    Services offered: PSD to Wordpress, Joomla, Drupal Templates or Full Site, Custom PHP or C# Programming, Fix problems on any software, and more.

    You will get 25% OFF all services by mentioning the Warrior Forum. PM me here or email me to ivanphp404@gmail.com if interested and/or if you have questions.

    {{ DiscussionBoard.errors[10478123].message }}
  • Profile picture of the author richasharma
    Use Mysql it is free and good. so many small companies still uses it as database. Or you can use SQL database there is not much difference in coding of both.
    Signature
    IT Services in Chhattisgarh
    {{ DiscussionBoard.errors[10481778].message }}

Trending Topics