August 14, 2003 at 4:16 pm
Hello all
This is my first visit. I was referred here by the MS SQL XML newsgroup. I hope you'll be able to answer this question.
I'm putting together a MS Windows SharePoint Service site with MS SQL Server as the back-end. I'm going to be using MS InfoPath as a front-end to complete some forms I've designed. As I'm sure you know, InfoPath's format of choice is XML.
I've got data in the form of straight text (.txt). Its a couple of thousand names with other pertinent labeled info. Is there a way to import this text into SQL and add the same labels on-the-fly? Once this data is imported, query info will be used to complete additional InfoPath forms. Being able to add info will be another function of this SQL database.
TIA
Wil Hodge
Wil Hodge
How do I make this work!
Wil Hodge
How do I make this work!
September 14, 2004 at 9:00 am
I'm not sure I understand fully what you are trying to do but I will give it a shot.
In Enterprise Manager, select the server you want to import to. At the top there is an "Run a Wizard" icon. Click on this, select Data Transformation Services, then select DTS Import Wizard. You will click next to come to the "Choose a Data Source" menu. Select Text File from the menu and you will get a field to upload the document. Once you do this, click nect and you will be able to choose what type of alignment you want (i.e. columns seperated by tabs or characters). Check the box "First row has column names". On the next screen you should see you information, make sure that you columns are seperated correctly. Select the database you want to copy the file to. Select next, and run the service now. Once this has finished your table should show up with the information and correct labels.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply