Import spreadsheet using TransferSpreadsheet

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jer

    Import spreadsheet using TransferSpreadsheet

    I am using TransferSpreads heet 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

Working...