Data dump from Excel XP to Notes via an Excel macro?

[JoseQuiervo]

Is it possible to pull data from an Excel spreadsheet and have it dump into a Notes view? I had it set up to currently dump into Access without a problem, but have come across numerous issues going into Notes R5. Has anyone ever attempted this? If you have, could I see some of your code to make sure I haven't lost my mind. Thanks, it's muchly appreciated.

 

[pmonett]

The only way I know for an Office app to put data into a Notes database is via ODBC.
Since Office 97, there is an ODBC plug-in for Access. Maybe Excel can also use it, I do not know.
You could have Excel dump data to a simple text file (with a predefined seperator) and have Notes upload it instead. That would save the hassle of fighting with an ODBC link (although it is not that difficult).

Pascal.

 

[JoseQuiervo]

With ODBC, that's the approach I was going to use, but it is uncharted territory. Do you know anywhere where I could find the necessary tools to figure that out?

As for the export to text and then the import into Notes, I need this as automated as possible so unless last resort, I can't pursue that option.

 

[pmonett]

You first need to design an ODBC link to the database you want to fill. That is done in the OS itsef (Control Panel, ODBC).
For that, you'll need some DLL to declare the link with, plus access to the database via the ODBC link.
Once your ODBC link is working by itself, you can then (presumably) tell Excel to use it.

Pascal.

 

[JoseQuiervo]

I'll give it a shot, thanks for the help...I'll definitely be back and let ya know what I come up with.

 

[JoseQuiervo]

Ok, that seems to work the other way, from Notes to Excel but I would like a way to dump from Excel to Notes. The pieces are in place but the reverse connection isn't working. Maybe I'm too inexperienced but something is missing. Any ideas?

Again, thanks for all the help.