Hi,

I need some help on where I am stucked trying to export the whole SQL Server
database into Access database used for analysis. I am trying to do this
programmatically for a web app that a user will be able to download the
access file into a folder on the web server.

The problem is that I want to be able to have all the database objects
created when using DTS.DataPumpTask2.

Basically I have to create a .mdb file to export to each time, create the
table object for all my tables, and then run my code to data pump the records
into the Access table.

I need to accomplish the following programmatically before executing my
package:
1. Create blank .mdb Access database file
2. Create all database objects exist in SQL Server
3. Data pump all tables' records. (I am doing one table right now specifying
the table name for the SourceObjectName and DestinationObjectName property.)

Any knowledge article, comments, help would be greatly appreciated,
Michael

Customer specific price matrix design (Long)
Update Query question.
The command(s) completed successfully. - Can i turn this output off?
preparing monthly report
Multilingual database design