Delphi 2006 and Microsoft SQL Server Express 2005

[CarrahaG]

Hello

We are new database programming in Delphi 2006. We are using Microsoft SQL

Server 2005 Express. Can give us pointers as to which component we could use to

run the SQL BULK INSERT command. We want to use a TBitBtn component which when

clicked would run the BULK INSERT command.

Using the SQL Server Management Studio Express we can run the following query

successfully:

BULK INSERT EDS.dbo.Entity
FROM 'H:\Delphi Programming\Projects\Enig Document

System\Program\20071002.01\Entity-Exp2(~).txt'
WITH (
FIELDTERMINATOR = '~',
ROWTERMINATOR = '\n'
)

Can you recommend which component we should use? Also, how can we trap erros

that occur so that we can give the user some indication of a failure?



Regards,
Georges

 

[DjangMan]

I suspect you should be able to use a TADOCommand.