Disclaimer Posted April 26, 2010 Report Share Posted April 26, 2010 I'm hoping an IT nerd or two can help me out with this.I've searched regarding ways to take a PDF form and have it import data from an Excel sheet. Basically, I made this "label" - we'll call it, and it can have 13 fields populated. I'm trying to create a Dynamic Stamp that'll auto-populate with imported data from Excel.I've tested the export to a txt file, and it'll import/export fine, but as soon as I import the txt file into Excel and resave it with the values I want (not the test cases) using the Tab delimited format, and I've also tried MS-DOS format -- Acrobat will no longer import the text data. I am make sure the Form value titles/variables are correct.Note that I do NOT have Acrobat Professional, just Standard and it's only version 6.0. And I've also tried using the xfdf export from Acrobat in hopes of using XML, but Excel doesn't like that either.Any thoughts? I haven't went the Javascript route because I don't have Acrobat Pro (and the project really isn't worth coding) -- just wondered if there was some simple trick or something I'm missing.TIA. Quote Link to comment Share on other sites More sharing options...
Tonik Posted April 26, 2010 Report Share Posted April 26, 2010 You have the fields labeled in the PDF....and excel labeled with the same names? That should do it, export exel to tab delimited...then import into Adobe. Quote Link to comment Share on other sites More sharing options...
Disclaimer Posted April 26, 2010 Author Report Share Posted April 26, 2010 Yep, same names. Still no dice. Quote Link to comment Share on other sites More sharing options...
CBR600rr Posted April 26, 2010 Report Share Posted April 26, 2010 Import form in to Google Docs-Forms...and then export ithttp://www.google.com/google-d-s/forms/ Quote Link to comment Share on other sites More sharing options...
Disclaimer Posted April 26, 2010 Author Report Share Posted April 26, 2010 That might be a viable solution if it were just for me... but I'm looking more toward automating the process for less savvy users. Quote Link to comment Share on other sites More sharing options...
CBR600rr Posted April 26, 2010 Report Share Posted April 26, 2010 You should be able to streamline all your commands in Google Forms. Google docs is for less tech savys Quote Link to comment Share on other sites More sharing options...
Likwid Posted April 26, 2010 Report Share Posted April 26, 2010 Just don't forget to clear out the cost basis Quote Link to comment Share on other sites More sharing options...
Bad324 Posted April 26, 2010 Report Share Posted April 26, 2010 Have you tried comma delimited or whatever? I think its CSV file. That is the way I had to do it at work for one of our programs that hates excel filed Quote Link to comment Share on other sites More sharing options...
r1crusher Posted April 26, 2010 Report Share Posted April 26, 2010 Justin....I have an idea that might work out better for ya. Call me when you get a couple free minutes. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.