Re: TransferSpreadsheet to .ADP dbo table

Hi Dave,

The TransferSpreadsheet command is fine.  The problem is with the ADP.
TransferSpreadsheet would work more reliably with an MDB.

With the mdb you can easily read your excel data into a local table with
Transferspreadsheet and then push that data to the sql server using ADO.

I would recommend using a separate mdb for im****ting your excel data if
you want to stay with TransferSpreadsheet. Otherwise, I would recommend
stepping up to .Net for interfacing with sql server and excel (much
easier).

Rich

*** Sent via Developersdex http://www.developersdex.com
***