Fetching the Data from Row 1 (SQL)
This code requires the samples SQL database. The file customer.dbtex is created using:datatooltk --output customer.dbtex --sqldb samples --sqluser sampleuser --sql "SELECT * FROM people WHERE surname='Parrot'"Alternatively you can use datatooltk-gui to import the data and save it to a file called customer.dbtex.
\documentclass[captions=tableheading]{scrartcl}
\usepackage[utf8]{inputenc}
\usepackage[T1]{fontenc}
\usepackage{datatool}
\DTLloaddbtex{\people}{customer.dbtex}
\begin{document}
\DTLassign{\people}{1}{%
\Surname=surname,%
\Title=title,%
\AddressI=address1,%
\AddressII=address2,%
\Town=town,%
\County=county,%
\Postcode=postcode%
}
\begin{tabular}{l}
\Title\ \Surname\\
\AddressI\\
\AddressII\\
\Town\\
\County\\
\Postcode
\end{tabular}
\end{document}
Download sample-assign-row1-csv.tex or sample-assign-row1-csv.pdf.