Creating a database from an existing InfoPath form

[Sandy Wood]

I've downloaded a pretty slick InfoPath form template that does everything I
need and now I'd like to ultimately create a corresponding database to store
the data. Is there an easy way to create a database from InfoPath - either
Access or SQL?

 

[S.Y.M. Wong-A-Ton]

Unfortunately, there isn't. You would have to create a database manually in
both cases.

S.Y.M. Wong-A-Ton

 

[Dean]

Here is an idea, export the Infopath data to Excel, then in Access import
the Excel sheet and create a database table. Haven't done this but it may
help you avoid rekeying field names.

 

[Sandy Wood]

That's a great idea! I'll give it a try!
--
Sandy Wood
Orange County District Attorney

Here is an idea, export the Infopath data to Excel, then in Access import
the Excel sheet and create a database table. Haven't done this but it may
help you avoid rekeying field names.