Timeline for Fixed length text file insert into SQL table
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 22, 2013 at 14:37 | comment | added | webdad3 | Jusiticator - my example is very rudimentory. The actual data I have is proprietary so I can't put that here. I'd love to see a working example though. | |
| May 16, 2013 at 14:48 | comment | added | Roi Gavish | @SQLFox I will search for the sources that helped me do it, it was a long time ago... I can also write an example for Jeff, I just need a few more lines in his example, and the structure of his destination table. | |
| May 16, 2013 at 13:41 | comment | added | SQLFox |
Not having experience with FORMAT FILE, I've looked into it briefly, but I haven't seen an example that addresses files like the example, where the header has one set of columns, the data rows another, and the footers another. Can you suggest a source for info?
|
|
| May 15, 2013 at 13:34 | history | answered | Roi Gavish | CC BY-SA 3.0 |