Skip to main content
jason_kane
Participant
December 26, 2015
Question

Import employees using XML and Excel into ACA 1095-C PDF form

  • December 26, 2015
  • 2 replies
  • 2311 views

Greetings,

I'm new to the forum community, so I'll try and keep this concise.

As a regular user of MS Excel and Access, I've created our own database program to hold all information for the new 1095-C form.

I believe I know how to import a single employee data-set to a blank 1095-C, but how can I "merge" all employees in one "sweep"?

I'd rather not have to do each employee import one at a time.

Could anyone shed some light on this?

I realize there is a level of complication to this, but we are NOT required to file electronically. This is only to create the employee copies.

Thank you so much!

This topic has been closed for replies.

2 replies

December 29, 2015

In the trying-to-offer-helpful-advice department, I asked one of our PDF experts, and he suggested the following:

Best to do it as two passes

1 – Do each individual employee

2 – merge the individual ones together into a single PDF (assuming that is what they want as the final output)

jason_kane
Participant
December 30, 2015

Sorry about posting in the wrong area. I looked and looked through my options but couldn't seem to find a forum that made sense to me.

Yes, that is what I think I saw as my best option as well. I wasn't sure if it was possible to import a text file with multiple records in a "mail-merge" concept.

I tried this with some basic dummy data, but I was required to only select one "row" of data for the import. I couldn't do all of them at once into multiple 1095-C forms.

So I presume the import "mail-merge" idea is not possible with a pdf form?

If not, I suppose I'll do it as individual passes; It'll just take a bit longer.

Thanks for your response regardless. Really appreciate it!

December 30, 2015

Best of luck! And, Happy New Year!

December 29, 2015

Unfortunately, this project, Mapping Resources for PDF, has absolutely nothing to do with your issue/question. Sadly, I cannot offer any helpful advice on your matter.