I've been advised the data merge to the fillable form requires java script. I changed the excel data file to a txt file. This appears to merge into the fillable pdf form however only one line of a 400+ database. Can anyone let me know how I can import my database into a 2page Adobe fillable form? Desperately need to resolve this ASAP. Thank you.
This operation is called a Mail Merge. It requires reading the contents of the text file and then processing it one line at a time, importing the data into the fields and then saving each copy under a unique name.
If you're interested I've developed a (paid-for) tool that will do all of that for you. You just need to select the input file plus some additional settings. It can even automatically email the files to the people from your DB, if you wish.