Copy table from Excel

Avatar

Avatar
Validate 1
Level 1
americanmn
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
americanmn
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
americanmn
Level 1

05-12-2011

Is it possible to copy a table out of excel or word and paste it into an Adobe form?  If so when I build the form what do I need to do?

View Entire Topic

Avatar

Avatar
Give Back 3
Level 2
past-tense
Level 2

Likes

9 likes

Total Posts

85 posts

Correct reply

10 solutions
Top badges earned
Give Back 3
Give Back
Validate 1
Boost 5
Boost 3
View profile

Avatar
Give Back 3
Level 2
past-tense
Level 2

Likes

9 likes

Total Posts

85 posts

Correct reply

10 solutions
Top badges earned
Give Back 3
Give Back
Validate 1
Boost 5
Boost 3
View profile
past-tense
Level 2

05-12-2011

I'm not aware of any way to directly copy multiple excels cells into multiple form fields, wihtout doing each cell individually. There is a bit of a waorkaround that you can use, though... you can create an excel workbook which binds itself to an xml data source whose schema matches that of your form. This can be a bit time consuming, especially when you bring repeatable subforms into play, but when done correctly, you can fill the data in the excel document, output it to an xml file then bind that xml file to your form.

Alternatively, if you can transpose the data from Excel into an MS SQL server, you can build a query the quite easily outputs xml by using the 'for xml' directive. I do this for a buch of our forms that we populate from various databases, and it's very straightforward.

let me know if either of these options interrest you, and I'll be happy to provide more detailed instructions.

- Scott