Results 1 to 7 of 7

Thread: Connect to (Import) external data

  1. #1

    Connect to (Import) external data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    HI

    I've read the MS help detailed above.....Is there something more I can read to help my understanding?

    I would like to learn how to set up data connections to an as400 based (old) erp system..through ODBC I beleive?

    Oh! is this the right place to post this type of question?

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    Hi there, and welcome to the forum!

    I assume that you're looking to connect to the database using VBA? I have an article on my site to retrieve data from a database that you can find here. Be aware, however, that the article connects to an Access database.

    The methods should be very simliar though, but you would need to update the connection string to something that is compatible with the as400. I found some connection string for the as400 here that may work. (I can't test that part as I dont' have access to an as400 system.)
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Thanks Ken...
    I will look at this code and copy it.
    I will also post I here how I succeed or otherwise.
    I was not actually thinkin g of vba...I was hoping that you could just export a data set into a data table ( 2007) using a scheduled task
    using the data: conections part of the ribbon (2007).
    I'm hoping that I will get help from someone with the as400 side...
    Llets wait and see.

    Thanks again
    Sinner01

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    I would think you could... you may have to install an ODBC driver for the as400 (if you haven't done already). At that point, you should be able to build your connection right against the server...

    Do you have a driver installed?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    Hmm.. where do I go for them/it. I think it is a 64 bit laptop? Thanks for the info

  6. #6
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    Great question...

    I did a bit of searching and turned up an article that may be helpful: http://www.as400tutorials.com/as400-to-excel/

    It makes reference in the article to: "AS/400 and iSeries ODBC driver comes with Client Access and is available as an option when you install Client Access on your PC"

    This MAY be what they are referring to: http://www-03.ibm.com/systems/i/soft...dbc/index.html

    I hope it helps,
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  7. #7
    Wow..Ken thank you very much..I've note tried the links yet but I'm impressed with your dedication to respond so quickly and to keep on doing it...thanks again. sinner01

Posting Permissions

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