Exporting Sql data to MS Access

Hello,

I'm trying to export data to an MS access database from a sql database but am having problems with mapping the sql data to the table i created in the destination database (using ADOX). Any ideas?

Cheers.

What kind of problems are you running into? Do you have any examples of issues you've hit so far?|||

If the destination table already exists, your best solution would be to create the "base" package by using the Import and Export Wizard, which creates any required conversion transformations for you. You can tweak the package, and add on to it, from that point.

-Doug

|||

I've got the package created that gets data from a sql server, creates an access database (and creates a hard-coded table that I know will fit the data) and dumps all the data into it. What I need to do now is to get data from a number of different tables using a PK _id and INNER JOIN and a WHERE _id = ? (or @.param) statement. So I need to create a variable _id that I pass to the constructor (and property) which gets all the data, creates the appropriate tables on the fly (without hardcoding) and dumps the data into the new access database.

Main problem at the moment is:

using a SQL command with a parameter that fills a rowset (Accessmode = 4?) and creating a bunch of linked tables on the fly to fit that data that fills the source rowset.

Any ideas?

Thanks again,

Emmett