Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Data to Notes

Status
Not open for further replies.

kev1609

IS-IT--Management
Aug 16, 2002
4
0
0
GB
I wish to import Data from an existing MS Access Database to a Newly Created Notes DB. Can you please help me with this
 
You should be able to write an agent or LotusScript on a button that will do this. You will probably have to create an ODBC connection and then write SQL statements and loop through the result set and create a new document for each record and then fill in the fields of the document with the appropriate fields from the database. See thread245-404298 for information on connecting to the ODBC and writing SQL queries.

HTH Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top