Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-03 : 07:23:16
|
| Justin Heard writes "How do you confiqure you microsoft email (outlook) to automatically import an excel spreadsheet file into an Orcale database?" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-12-03 : 08:47:33
|
Let me get this straight... You want to use Microsoft Outlook to import a Microsoft Excel spreadsheet into an Oracle database?That sure sounds like the right way to go about it...  |
 |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-12-03 : 09:17:17
|
| Well technically you can write a plug-in that would do this in C++, but I more with Andraax on this one, why are you doing this?***************************************Death must absolutely come to enemies of the code! |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-03 : 17:02:03
|
| I believe you can write vba code in outlook and use ADO to read the spreadsheet and insert into the database.Look under Tools-->Macros-->Visual BasicYou might have to use a filter to kick off the vba code.If you're trying to process attachments you might want to place them all in a folder and then schedule a transformation job in oracle. Lightens the load on the email server and probably faster too.Edited by - ValterBorges on 12/03/2002 17:04:36Edited by - ValterBorges on 12/03/2002 17:05:17 |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-12-04 : 09:20:18
|
| Pretty good suggestion ValterBorges, can't believe I didn't think of it though.***************************************Death must absolutely come to enemies of the code! |
|
|
|
|
|
|
import email into database automatically