On May 8, 3:59 pm, D.St...@[EMAIL PROTECTED]
wrote:
> I'm getting a problem with im****ting an Excel spreadsheet into a table
> in a SQL Server 2000 back-end. I'm doing this in VBA in an onClick
> event proc in an Access 2003 project.
>
Further info:
I thought it might help if I prefixed the target table name in the
TransferSpreadsheet call with 'dbo.', so the VBA line now reads:
DoCmd.TransferSpreadsheet acIm****t, , "dbo." & tempTab, strFilename,
True, "MyRange"
In fact, this gives an error (3078) because the table name generated
is 'dbo_mytab' instead of 'dbo.mytab'.
I also find that TransferText behaves the same, i.e. it creates a new
table belonging to 'fred' rather than use an existing one belonging to
'dbo'.
Cheers,
Dave


|