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.