help

[zoey]

We need to import data from a table in access to sql server 7.0 database on a monthly basis. However, their is an additional field in the table in sql server that needs to be populated with a date that the user should be able to specify. I would like to make this as much automated as possible. What's the best way of doing it?

thanks
Rozina

[Ananth]

Your requirement is a little vague. Working on the assumption that for a given month, the user specified date is the same for all rows, the simplest approach would be to create a one row table in Access, and update a date field in it; then write a query selecting all the columns from the main table, and the date from the one row table...if you don't specify a join clause, you will get a cartesian product of 1 X rows from the main table, which is what you need. Then use the query as your source in the DTS package.


------------
zoey at 6/8/01 5:38:41 PM

We need to import data from a table in access to sql server 7.0 database on a monthly basis. However, their is an additional field in the table in sql server that needs to be populated with a date that the user should be able to specify. I would like to make this as much automated as possible. What's the best way of doing it?

thanks
Rozina