?
Solved

Where are the XML Format Files

Posted on 2011-02-27
5
Medium Priority
?
348 Views
Last Modified: 2012-08-13
I do not want to have to create thirty or so XML/Text Format Files by hand. I assume the SQL Data Import utility saves the format file somewhere. Can you please help me find it or suggest another, GUI-based, quick method/script option to create a bunch of format files. I eventually intend to use the bcp utility and the format files to automate data imports. any guidance appreciated. thanks!
0
Comment
Question by:HankinCooper
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 34994943
I am not sure I am following. Are you trying to to export data from the database into a Text file?
0
 

Author Comment

by:HankinCooper
ID: 34995105
import data into the database using the bcp command line tool. My understanding is I need a format file to suppliment this inport which the import/export data seems to facilitate. I asuume those format files are stored somewhere or am hoping there is a quicker way to create a format file other than byhand...
0
 
LVL 17

Accepted Solution

by:
pssandhu earned 1500 total points
ID: 35000690
See if this helps: http://support.microsoft.com/kb/67409

There is a question half way down the page that addresses your question.

Hope this helps.

P.
0
 
LVL 17

Expert Comment

by:pssandhu
ID: 35000718
What format is the data currently residing as?
0
 

Author Closing Comment

by:HankinCooper
ID: 35023793
Thanks, helped but still a manual process. thanks.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question