How to link Excel with Lotus Notes?

I am developing together with As/400 and Lotus notes and i am retrieving data from AS400 to Excel then i need to put them into Lotus notes can i go about doing it?i tried FileImport cannot...ODBC how?    
Who is Participating?
q2eddieConnect With a Mentor Commented:
Hey, Codec.

I don't mean to be rude or anything, but you have several open questions.  While it would be nice for you to close those questions, you don't have to.  However, you should let the other experts know if their suggestions helped you or not.

Anyway, here is some information that might help you.

' ODBC Connection String (DSN-less)
lcConnString = "Driver={Client Access ODBC Driver (32-bit)};" & _
               "System=myAS400;" & _
               "Uid=myUsername;" & _

' OLE DB Connection String
lcConnString = "Provider=IBMDA400;" & _
               "Data source=myAS400;"
               "User Id=myUsername;" & _

1. "How To Set Up ODBC Connectivity To An AS/400"

2. "A Fast Path to AS/400 Client/Server Using AS/400 OLE DB Support"
(Look for the RedBook link in the upper right hand corner.)

Bye. -e2
do you need the excel ? 'cause you can also get the data directly from the AS/400 with odbc maybe ?
tgebruikCommented: are right!!

IBM is very proud to have an "open" system for Notes, so we better use it....  :-))
ZvonkoSystems architectCommented:
No comment has been added lately (988 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to q2eddie http:#6164254

Please leave any comments here within next four days.

-- Please DO NOT accept this comment as an answer ! --


EE Cleanup Volunteer
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.