Professional Web Applications Themes

Data Merge SQL Server/MS Access - Adobe Indesign Windows

Hopefully, I can explain in a concise paragraph. We are a County Department that has utilized SQL Server Database to collect our data through the Web. We used MS Access as an application with VBA to publish our Budget in MS Word Templates. This past year, it was very difficult because the generation of hundreds of MS Word doents for every revision. This was a nightmare. We are in the process of purchasing Adobe InDesign. We would like to know if purchasing this product will allow our department to better control the generation of only 22 Departments files of program ...

  1. #1

    Default Data Merge SQL Server/MS Access

    Hopefully, I can explain in a concise paragraph. We are a County Department that has utilized SQL Server Database to collect our data through the Web. We used MS Access as an application with VBA to publish our Budget in MS Word Templates. This past year, it was very difficult because the generation of hundreds of MS Word doents for every revision. This was a nightmare.

    We are in the process of purchasing Adobe InDesign. We would like to know if purchasing this product will allow our department to better control the generation of only 22 Departments files of program information and budget data as opposed to 180 files. I noticed that the product offers data merge. Currently, we have various databases that contain key fields that ties the data together. For one department, we would set up a multiple pages in one template. In this example, the department would have a total of 10 programs plus 10 budget data sheets. Some departments may have more programs but the templates will be control within one file.

    My question is can these fields be mapped to the specific templates? Can edits be done to the data on this template and it will be ted on the SQL Server? Or is there another solution with this product?
    Fernando_Angell@adobeforums.com Guest

  2. #2

    Default Re: Data Merge SQL Server/MS Access

    I have successfully used the Data Merge feature with Indesign and it was a HUGE help. You have to export your data to a tab or comma delimited file before you can import into InDesign - so there's that extra step - but it works well.
    JulieASmith@adobeforums.com Guest

  3. #3

    Default Re: Data Merge SQL Server/MS Access

    Thanks!
    Fernando_Angell@adobeforums.com Guest

  4. #4

    Default Re: Data Merge SQL Server/MS Access

    Hi,

    The re is a client which has 10000 databses in ms access . we need to move it to sql server.

    twhats the best approach
    Jo tha Guest

Similar Threads

  1. CAN YOU DO A DATA MERGE ONTO A DOENT
    By ryanm72@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 2
    Last Post: September 26th, 09:46 PM
  2. DATA MERGE.....
    By ryanm72@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 4
    Last Post: September 26th, 04:00 AM
  3. Replies: 31
    Last Post: June 25th, 11:29 PM
  4. Subform data select on access/ sql server database
    By Justin Levett-Yeats in forum Microsoft Access
    Replies: 0
    Last Post: July 21st, 05:46 PM
  5. Extending client to access Excel files (most data still in SQL Server)
    By Christopher Stolte in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 16th, 01:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139