I have a fex that we run every quarter that I would like to append the data into a table in MSSQL at the end of every quarter. I've created tables in MSSQL using a permanent hold file but never tried appending data in an already existing table. Anyone know the correct syntax to do this?

This message has been edited. Last edited by: <Kathryn Henning>,

If you use sql passthru, you just insert the new records using the insert command. If that doesn't work for your situation, could you provide more details?

-EDIT: If the users are entering data on a form, it will be easy to use those variables in a sql passthru statement. If you are running a report and expect that output to be inserted, you could read the results into variables and then call a sql passthru statement, but there may be a better way to do that.

Thanks
J

This message has been edited. Last edited by: J,

Yes, I had planned on using either a SQL passthru or a modify command to append the data.

So, for example, if I have a focus table with 100 rows in it, can I just use a SQL passthru with a standard SQL insert command to append those 100 rows into the MSSQL table?

quote:

Originally posted by J:
-EDIT: If the users are entering data on a form, it will be easy to use those variables in a sql passthru statement. If you are running a report and expect that output to be inserted, you could read the results into variables and then call a sql passthru statement, but there may be a better way to do that.

You responded too quickly