How to export a dataset to MS-Access (MDB)

[Yazster]

Hi All,

I have a web page that displays the contents of a dataset to a datagrid in a web page (using paging). I currently have the ability to export to Excel, however users now want to also be able to export to MS-Access.

I basically use the following technique to export to Excel:

response.Clear()
response.Charset = ""
response.ContentType = "application/vnd.ms-excel"
response.AddHeader("Content-Disposition", "attachment;filename=MyExport.xls")

Unfortunately I can't seem to get this to work with MS-Access. Has anybody been able to do this?

Thanks a million!
Yazster

 

[jbenson001]

I think you would have to export the data to a file, txt or csv, and then manually import into access.

 

[Yazster]

Thanks, unfortunately that's not really an option, since my end-users don't know how to do this.

I was really hoping there was an easy straightfoward method like Excel...

 

[jbenson001]

I don't think there would be a direct way. Try searching on Google.

 

[ca8msm]

It's not as straight-forward as Excel. You'll have to use the Access Object class itself to create a new database, import the data, save the file and then stream it back to the client.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.