I am using TransferSpreadsheet from an ADP file to import an Excel
spreadsheet into an MSDE database. On one computer, when I run the
code to
import the spreadsheet, it prompts for an SQLServer login. The same
user can
try it on a different computer and it will work fine. Data in the
tables of
the database can be viewed and edited on the bad computer. But the
spreadsheet cannot be imported. I even tried the Get External
Data->Import
menu option and it prompts for SQLServer login also.
Any ideas on what to look at on this computer to determine the problem?
Or any suggestions for a better way to import a spreadsheet into an
SQLServer database (it must be imported every two weeks)?

Thanks!
Jerry