Import CSV

  Import one CSV into two Tables Import CSV Video 1 (2:15) Import the Comma Separated Value file (CSV )into a staging table. Then run two queries against the staging table. One query to extract “H” into a new table, the other to extract “R” into a new table. Video 1 (2:15) More Info on Import CSV:- … Read moreImport CSV

Display Field Data Horizontally

Transform, Concatenate Examples A common requirement in MS Access is to extract Columnar data into horizontal data, for instance to make reports look better, to provide a list of emails suitable to send to with Outlook. In the YouTube videos below I explain how this can be done. …         ..      … Read moreDisplay Field Data Horizontally