Access Form + button Click + create csv file from SQL Server table data RRS feed

  • Question

  • HI,

    My requirement is that sql server table has data. User is using Access Form to insert data into that table using linked table. After data is entered into table using access form, requirement is to provide a button to export table to csv file.

    1) Access Form

    2) Sql server table as linked table

    3) Create CSV file

    I was thinking of creating a stored procedure in sql server which executes SSIS package to generate csv file. From access FORM, call this SQL server stored procedure

    I would like to know what is the best option to generate CSV file. If my approach is also one of the options, can you please guide me how to do it.

    Thank You

    Wednesday, May 10, 2017 7:59 PM

All replies