Results 1 to 6 of 6

Thread: COMBINING DATABASE TABLES

  1. #1
    Email problem
    Join Date
    Jul 2012
    Location
    Gauteng
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts

    COMBINING DATABASE TABLES

    Hi guys,

    I know it is possible to pull data through from excel from multiple databases. I have a basic understanding of sql (Microsoft server management studio) and I have been playing around with the Data tab "import from other sources" tab.

    Now here is where it gets overwhelming. Do I use OLEDB or ODBC or can I query straight from sql? and if so guide me in getting this information into one dataworkbook. I know how to use the select function to select certain columns but it seems at this stage i will have to combine 2 tables per database. (3 databases in total).

    ANY guidance welcome.

    PS pulling the info from Pastel evolution so if you have a smart BIC person out there to help please! (I only have standard not advanced version)

  2. #2
    Email problem
    Join Date
    Jul 2012
    Location
    Gauteng
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts
    the Data tab "import from other sources" - in EXCEL

  3. #3
    New Member
    Join Date
    Jul 2012
    Location
    South Africa
    Posts
    8
    Thanks
    0
    Thanked 1 Time in 1 Post
    Jonesey,
    I would use the import from other sources and ODBC to get the data from the tables. I would bring the tables in into separate sheets and then look at combining the data. Without a bit more info on what you are trying to achieve that is the best I can supply at this point.
    I would be careful as I thought Pastel did not use a standard SQL but I may be a little out of date there. especially as evolution is their latest product.

    I would proceed slowly though. Bring in one table and get used to using the import functionality before going for multiple tables.

    Regards

    Tim

  4. #4
    Email problem
    Join Date
    Jul 2012
    Location
    Gauteng
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Tim,

    yeah Evolution is pretty powerful and unlike the lesser products in the range which work on pervasive actual has standard sql capabilities. It is amazing what you can do with this package with a little knowledge.

    Thanks - going to play a bit this week and then ask more pertinent questions if and WHEN I get stuck.

  5. #5
    New Member
    Join Date
    Jul 2012
    Location
    South Africa
    Posts
    8
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by jonesey View Post
    Hi Tim,

    yeah Evolution is pretty powerful and unlike the lesser products in the range which work on pervasive actual has standard sql capabilities. It is amazing what you can do with this package with a little knowledge.

    Thanks - going to play a bit this week and then ask more pertinent questions if and WHEN I get stuck.
    Enjoy the play and thanks for the update on the SQL. You may also like to look at what Mr. Excel can offer. his site is here and he offers great advice and also downloads of some really neat tricks. You can always learn something from one of his webcasts.

  6. #6
    New Member
    Join Date
    Jul 2012
    Location
    South Africa
    Posts
    8
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi Jonesy this just dropped into my inbox and I thought that you might like to have it http://bookboon.com/en/business-eboo...-non-students2

  7. Thanks given for this post:

    jonesey (30-Oct-12)

Similar Threads

  1. Database problem
    By Scaffold in forum General Business Forum
    Replies: 6
    Last Post: 23-Nov-11, 08:55 AM
  2. [Question] Changing Database name for Company in Pastel
    By J7J in forum Accounting Forum
    Replies: 1
    Last Post: 14-Apr-11, 01:48 PM
  3. 2011/2012 Tax Tables
    By Pastel Payroll Consultant in forum Tax Forum
    Replies: 0
    Last Post: 07-Mar-11, 10:37 AM
  4. National consumer database
    By Dave A in forum General Business Forum
    Replies: 2
    Last Post: 10-Mar-09, 07:22 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •