Connect to (Import) external data

S

sinner01

New member
Joined
Apr 7, 2011
Messages
6
Reaction score
0
Points
0
:confused2::confused2: 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?

:becky:Oh! is this the right place to post this type of question?
 
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.)
 
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
 
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?
 
Hmm.. where do I go for them/it. I think it is a 64 bit laptop? Thanks for the info
 
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
 
You must log in or register to reply here.
Back
Top