Insert values from BLS transactions into tables thru query templates

[Former Member]

Hi All,

I am trying to insert values which I get from the BLS transactions into the tables through query template. But, I dont know the procedure. I get the values of Equipment, Failure Date and Time, Failure Duration, and Section from the BLS. And I want to dump it into a table having these fields in Access.

Can anybody please help.

Thanks in Advance,

Lipsa.

[Former Member · Accepted solution]

Hi Lipsa,

The ultimate aim is to insert some data in to DB.

Use SQL query in command mode.

In Fixed Query Tab, write the restive query using the params.

Example: if you have table name with two columns then

insert into <tablename> values ([Param.1], [Param.2])

Then call this query template in the same BLS assign the parameters respectively.

Link the values with Param.1 and Param.2

Hope this will solve your problem.

Regards,

Kishore kumar P.S.