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 - 2001-04-24 : 12:04:11
|
patti writes "Hi there SQLTeam!
We receive a daily e-mail which contains an
excel spreadsheet as an attachment.
The contents of the excel spreadsheet is
to be loaded into a SQL 7.0 (sp 3) db
on a W2K server.
We would like to automate the entire process
as a SQL server scheduled job. I also have
SQL mail installed on the W2K server.
What is the best approach to this automation task?
I'd really appreciate as much implementation
detail as possible.
Thanks VERY MUCH for any/all help,
Patti" |
|
|
|
|
|
automatic update of a SQL db with a daily email .xls attachment