Post reply

dumping into an access file (.mdb)

  • September 30, 2008 at 7:42 am

    #96748

    I have a view in SQL Server 2005 and there is a requirement wherein we have to dump all the records from this view into an access (.mdb) database at some locations (the locatin could be some where the front end application is installed or could be any shared location). Our reporting tool would pick this access database & use it for reporting (the reporting tool can read fdata rom the access database only).

    I'm interested to know the various methods we can do it either from SQL Server or from the front end application (.Net C#).

    Thanks.

  • September 30, 2008 at 8:40 am

    #878900

    - SQL Server includes SSIS - which could be used for this.

    - You could create a linked server on your SQL Server to write directly to the access database

    - You could create a linked table in the access database to link directly to your SQL Server

    - You could read from your SQL Server into a recordset in .Net and then write the recordset to your access database

    All of these are fairly easy and will depend on your environment. My first suggestion, however, would be to get a better reporting tool. It's hard to believe there is anything that is remotely good that cannot read from an MSSQL database.

  • September 30, 2008 at 9:32 am

    #878936

    Thanks, Mike. I actually didn't know about linking the file from access to SQL Server. I have now few tips to bring a solution to our requirement.

    For the last point, reading from view & dumping through a recordset (using .net application), I'm thinking if the volume of records are more whether it would impact the process. At this moment I dont have an idea how big this view would be.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply