Hi,

I would like to create a SP to execute a BULK INSERT.

If I run the following in QA - it works fine...

BULK INSERT ATMPOS.dbo.[TransactionDetails]
   FROM 'd:\testing99.txt'
   WITH 
      (
       FIELDTERMINATOR = '|',
	   KEEPNULLS
       )

However, if I try the following, it doesn't work

declare @PathVC varchar(100)

set @PathVC = 'd:\testing99.txt'


BULK INSERT ATMPOS.dbo.[TransactionDetails]
   FROM @PathVC
   WITH 
      (
       FIELDTERMINATOR = '|',
	   KEEPNULLS
       )

Can I not use a declared variabe containing the filename and path? Or, is there a better way to do this? I want to execute this from VB6.

Thanks in advance.