title: How to use metadata or have sql recall column width on a fixed width .txt file import
body: <p>Ill preface this by stating that I have searched and searched and have yet to find my answer.</p>
  
  <p>Long story short, I have a .txt file of around 1.5mm rows and 200 columns. The columns are all set fixed width that I ahve a metadata file for. I get a new file about every 6 months and have been entering the column widths manually. I am trying to figure out a way for sql to recall the widths or how to load the metadata so I can set it to that. The manual process is tedious and time consuming.</p>
  
  <p>It is highly possible that I am just searching the wrong keywords. Any advice would be great but guidance of where I can read and learn about this process would be better(still sort of a beginner here).</p>
  
  <p>thanks</p>