Saturday, February 25, 2012 11:53 AM
I have a number of separate text files which i would like to import into an SQL database. The data is not comma separted so that rules out using my idea of importing data by comma. However, the data is across a number of rows. See example text file below. Please could anyone advise how i could import specific data such as the programmed and mean values, shift number, etc?
Sunday, February 26, 2012 5:17 AM
I think in this case you need to write some (C# or VB) code to import your data to sql server or to format your text files to become CSV or something understandable to SQL server.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
Monday, February 27, 2012 9:26 AM
Could you recommend any tools to format the text files to make them more understandable?
Monday, February 27, 2012 9:33 AMYou can try http://www.bitwiseideas.com/FileFormat/Index.htm
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
- Proposed As Answer by koles Tuesday, April 10, 2012 9:52 AM