barry 50045 (6/19/2014)
Anybody,Does anyone know of a way that I can pull all of the data from all of my tables in my Sql Server Express 2008 database and convert it to a .mdb format? My company is taking over the support of a web application and moving it to a new server. The new server has a Sql Server Express instance running on it. The application is currently hosted at a location that has a full-blown version of Sql Server and accomplishes this task via SSIS. Currently, the user of the application can click a link on the website that allows them to download a zipped .mdb file onto their local machines.
Does anyone know of a way to do this without using SSIS? Please. I am at witts-end.
Thanks,
Barry
Eek your website allows users to copy the entire database? What purpose would this serve? You would have to get knee deep in the code here since you will have to do everything manually. Basically you will have to create an access database and then create and populate whatever tables you need via t-sql.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/