forum.techrabbi.com - XML to SQL

Forum start - Register

New message

You got 0 new message(s) in your inbox

To inbox Close

Forum start > pc > software > XML to SQL

Quickview

Author

Thread

JDOG
Member

Location:
Registered: 8/7/2006 Warnings: 0

XML to SQL
I am trying to come up with a little better solution at work than what we have. I would like to figure out how to export an Excel XML file into an SQL database. The file itselfs contains thousands of data entries with hundreds of columns. It's an absolute nightmare to look at. We just purchased a system for our hospital because of the Healthcare bill that provides incentives for going onto a national DB. Of course, the hospital administrators made the decision with only eyes on the money.

I have found a way to export it into an Access database with some success. But the file is to large to deal with access and it is not allowing me to work with it or import it into a data set with VS.

__________________
JDW
jdog44@gmail.com

8/24/2012 08:55

Link - Ip: Logged - Quote:


QuickView: XML to SQL - JDOG 8/24/2012 08:55
when you export it do you want it to stay in its current for... - byerspc 8/24/2012 11:54
I'm good with it staying in it's current form. Though relati... - JDOG 8/24/2012 15:19

Forum start > pc > software > XML to SQL

Quick reply

You need to login before you can post.