I often recieve a large amount of data in .csv format, +-60 headers and I need to copy this data to .csv with +-400 headers and hoping to get a template designed to automate this. The data concerned is for lab results that need to be stored in a database. The format of the supplied lab data changes according to the lab but the output format (this goes into the database) always need to be the same - The database uses column header matching when imported.
Example data attached [login to view URL]
47 pekerja bebas membida secara purata $164 untuk pekerjaan ini
Hello, I am a excel, csv, database, mysql, sql and Powershell expert, i can help you to parse the excel file and insert the data into db Please ping me for further discussion thanks