My question is Access related.
1) I have an access file with many tables.I want to replicate this access file but without data.Means I want to make a copy of the access file with the same tables with same design but without any data.How to do that?
2)In one of my DTS data goes from SQL to Access.I want to truncate few access tables before this DTS package is run.It should be done through SQL.How can I do that?replicate without data? what do you mean? any table change should result in a change on a table in sqlserver?
No comments:
Post a Comment